How to Copy a Number Without the Currency Symbol

A cell that shows $1,234.50 usually still *is* the number 1234.5. The dollar sign and often the comma are display format, not extra characters in the value. Copying the cell can carry the value, the format, a formula, HTML for a table paste, and a bitmap preview. The destination then picks a flavor. That is why a paste into Notepad, a web form, or a terminal sometimes includes $ and sometimes does not.

Windows clipboard history does not “understand money.” If the payload is text that already contains a $, history stores that text (up to 4 MB, among at most 25 items, wiped on restart unless pinned). If the payload is an Excel range, what Win+V shows is a preview, not a guarantee of a clean number.

This guide separates value, format, and text so the next paste is a number the destination can add, sort, or parse.

Value versus format versus what you see

Microsoft’s currency article is explicit: to display numbers as money, apply Currency or Accounting format. The value does not become a string just because a symbol appears.

Accounting format can put the currency symbol on the left of the cell and the number on the right. That is still a format. It is not two cells.

Copying formulas versus calculated values is the sister problem when the cell is a formula. The same Paste Special dialog solves both.

Fast path inside Excel

When the destination is another sheet or workbook:

1. Copy the cells (Ctrl+C).
2. Select the landing cell.
3. Open Paste Special: Ctrl+Alt+V, or Home > Paste > Paste Special.
4. Choose Values.
5. Confirm.

Microsoft documents Values as “formula results, without formatting or comments.” The landing cells get 1234.5, not $1,234.50, and not the original formula.

Useful neighbors in the same dialog:

• Values & Number Formats — keeps currency display. Wrong for this job.
• Formulas — keeps =A1*1.08. Wrong if the landing sheet has no A1.
• Multiply by 1 after pasting values — a trick to coerce text-numbers, not required if the source was numeric.

Keyboard after Ctrl+Alt+V: press V, then Enter.

If the whole column should stay numeric, apply a Number format to the destination first, then paste values. Do not apply Currency “to make it look right” and then wonder why the next export has symbols again.

When the destination is not Excel

Notepad, VS Code, a web form, a terminal

A direct Ctrl+V from Excel often pastes the displayed text, including $ and grouping commas, because those apps ask for Unicode text. Excel is being helpful.

Options, in order of safety:

1. Paste Special > Values into a helper column formatted as Number (no symbol, enough decimals). Copy that helper column, then paste into the other app.
2. =VALUE(SUBSTITUTE(SUBSTITUTE(TEXT(A1,"0.00"),",",""),"
   quot;,"")) is the wrong direction if A1 is already numeric. Use it only when A1 is text.
3. If the clipboard already holds $1,234.50 as text, paste into the editor and strip symbols with find-replace. Regex and find-replace beats a 'smart' clipboard.

For a terminal, treat the result as plain text and watch for commas: 1,234.50 may be two tokens. See Pasting into terminals: always plain text.

Word or Outlook

Paste options include Keep Text Only, which usually gives the displayed string ($1,234.50). To get a bare number into a sentence, convert in Excel first, then paste text. To get a table that still looks like money, keep source formatting and do not expect the Word table to be numeric.

Another finance or admin web app

Many portals parse $ and commas; many do not. If the field rejects $1,234.50, do not fight the portal with a clipboard macro. Produce 1234.50 in Excel and paste once. Locale matters: 1.234,50 versus 1,234.50. Match the portal’s locale, not the laptop’s decorative format.

TEXT, VALUE, and helper columns

Microsoft’s TEXT function renders a number as a string with a format code. That is the opposite of this article’s usual goal, but it is the right tool when the destination *wants* a fixed string without a live format:

• =TEXT(A1,"0.00") → 1234.50 as text
• =TEXT(A1,"$#,##0.00") → $1,234.50 as text

To go the other way, when someone has already given a column of text like $1,234.50:

1. =SUBSTITUTE(SUBSTITUTE(A1,"
   quot;,""),",","")
2. Wrap with VALUE(...) if the cell must be numeric.
3. Copy the helper column, Paste Special > Values, delete the formulas.

Do not run this on cells that are already numbers. SUBSTITUTE will coerce them through text and can drop precision or blow up on Accounting formats that use ( ) for negatives.

Accounting negatives and other landmines

Parentheses are format. A naive “delete $” leaves (1234.50), which many parsers reject. Prefer Paste Special Values from a numeric cell over string surgery.

Red font for negatives is also format. A text paste may lose the minus sign if the source relied on color alone — uncommon in Currency format, possible in custom formats. Check a known negative before a bulk copy.

What Win+V will and will not show

Copy a formatted currency cell, press Win+V:

• The preview may look like $1,234.50 because the text representation includes the symbol.
• Pasting from history into Excel may still paste a full cell (value + format) if Excel recognizes its own clipboard payload.
• Pasting that same history item into Notepad pastes text.
• A screenshot of the cell is a bitmap. History can store it if it is under 4 MB. It is not a number.
• Files are not a first-class history type. An exported .csv copied in Explorer will not appear as a reusable number card.

Do not pin a column of payroll figures in history. Pins survive restart. That is convenient for a tax ID format string and reckless for a salary list on a shared PC. How to pin items in Windows clipboard history and Clipboard history on a shared family PC apply.

History still only holds 25 items. Copying “just the number” twenty times while testing formats will evict other clips. Use a helper column.

CSV and “visible cells” side notes

Filtered rows: a normal copy can include hidden cells. Use Go To Special > Visible cells only (Alt+;) before copy if the number should not pull filtered-out amounts. How to copy only visible cells in Excel.

CSV: Save As CSV writes the values as text according to Excel’s export rules, which may or may not include currency symbols depending on format and locale. Open the CSV in an editor before sending it. Do not assume the clipboard’s HTML table matches the CSV.

A 60-second playbook

1. Confirm the cell is numeric (formula bar shows 1234.5, not '$1,234.50).
2. If it is numeric and the destination is Excel: Paste Special Values.
3. If the destination is a text field: helper column with Number format, copy that, paste once.
4. If the source is already text with a symbol: SUBSTITUTE + VALUE, then paste values.
5. Spot-check one negative and one thousand-plus value.
6. Clear the live clipboard if the numbers are sensitive (Win+V > Clear all, or Settings > System > Clipboard > Clear clipboard data). Unpinned items also vanish at restart; do not treat that as a security control on a machine that stays awake.

A clipboard manager is optional here. The missing feature is Excel’s paste dialog, not a longer history. A local shelf such as Edge-Drop can hold a cleaned CSV or a screenshot of a totals row for a slide, but it should not become a wallet of raw amounts. If the recurring job is “type this rate all day,” store the rate in the workbook or a snippet tool, not as a pinned clip.

How to paste without formatting on Windows removes fonts. It will not remove a $ that is already in the text payload. Strip the symbol in Excel, then paste.

A dedicated walkthrough is Right-to-Left Text on the Windows Clipboard.

Related reading

• Pasting Into Terminals: Always Plain Text
• Right-to-Left Text on the Windows Clipboard
• How to Paste Without Formatting on Windows
• A Sensible Daily Copy-Paste Workflow

Sources

• Paste options (Microsoft Support) — official Paste Special list including Values versus Formulas.
• Format numbers as currency in Excel (Microsoft Support) — Currency vs Accounting; value stays numeric.
• TEXT function (Microsoft Support) — rendering a number to a formatted string on purpose.
• Available number formats (Microsoft Support) — Number, Currency, Accounting, Text categories.
• Using the clipboard (Microsoft Support) — what history will store after the number becomes text.

Copy. Stack. Drop.

Transform your clipboard into an interactive edge shelf. Stack, pin, and drag assets into any app with zero friction.

Download for Windows Get from Microsoft Store

How to Install Guide · First 10 Minutes Guide · Drag & Drop Guide · Edge-Drop vs Win+V · Support