How to Paste Numbers Without Formatting on Mac
How to Paste Numbers Without Formatting on Mac
You copy a number from a spreadsheet, a PDF, or a web page — and when you paste it, it arrives with dollar signs, commas, decimal weirdness, or a font size that belongs in a different decade. This happens constantly on Mac, and there are several practical ways to strip that baggage before the number lands where you need it.
Why Numbers Carry Formatting When You Copy Them
macOS copies rich text by default. When you select a number in a spreadsheet like Numbers or Excel, the clipboard grabs the cell value plus its formatting metadata — font, color, alignment, number format. The same thing happens with text copied from web pages (HTML formatting) or PDFs (embedded styles).
When you paste into an app that also accepts rich text — another spreadsheet, a word processor, an email client — it uses whatever it received, formatting and all.
The Built-In Shortcut: Cmd+Shift+Option+V (or Cmd+Option+Shift+V)
In many macOS apps, the standard paste-as-plain-text shortcut is:
Cmd+Option+Shift+V
This tells the app to paste text only — stripping rich text attributes. It works in:
- Mail — pastes the number without inherited font or color
- Pages and Keynote — strips text styling but preserves the value
- Notes — works reliably
The catch: this shortcut does nothing in spreadsheet apps like Excel or Numbers when pasting into cells, because those apps have their own paste logic.
In Spreadsheets: Use Paste Special
Microsoft Excel
Copy your number, then use:
- Ctrl+Shift+V → opens Paste Special
- Or go to Edit → Paste Special → Values
Choose Values (not Formats, not All). This pastes only the raw number, ignoring any source formatting.
Apple Numbers
Numbers uses:
- Edit → Paste and Match Style
This pastes the value and applies the destination cell's existing format — which is usually what you want when building a clean table.
Google Sheets (in Chrome)
Google Sheets has its own shortcut:
- Cmd+Shift+V — pastes values only, no formulas or formatting
Intermediate Trick: Route Through a Plain-Text App
A classic workaround is to paste the number into a plain-text editor first — TextEdit in plain text mode, a Terminal window, or any code editor — then copy it again from there. The re-copy produces a clean plain-text version of the number, which you can then paste anywhere.
It works, but it adds two extra steps every time. If you're doing this repeatedly throughout the day, the friction adds up.
The Better Way: A Clipboard Manager That Strips Formatting
A clipboard manager keeps a history of everything you copy, so you never lose a number (or anything else) to a fresh copy. More relevant here: many clipboard managers let you paste any item as plain text on demand, regardless of what formatting it originally had.
ClipHistory is a macOS clipboard manager built in Rust and Tauri — a universal binary that runs on both Apple Silicon and Intel Macs. When you copy a number (or anything else), it's captured automatically. Your history holds the last 150 unpinned clips plus unlimited pinned clips.
Opening the history is Cmd+Shift+V. From there, you can search, browse, and paste — and ClipHistory auto-detects the category of each clip (URL, email, phone, number, code, color, text, image), so your numbers are easy to spot.
The practical win for this problem: you see the raw value in the history panel before you paste, and you have full control over what goes where. No more guessing whether Excel is going to import the dollar sign.
ClipHistory also includes AI Transforms — you can run a clip through a "clean/fix" transform to strip noise from a copied number before pasting. You bring your own API key (Anthropic, OpenAI, DeepSeek, Google, or a custom endpoint), so there's no subscription cost beyond the tool itself.
Everything stays local on your Mac. No cloud, no account required, no data leaves the machine.
Get ClipHistory — $19.99 (annual license, one payment, not auto-renewing).
Quick Reference: Which Method to Use
| Situation | Best Method |
|---|---|
| Pasting into a rich-text app (Mail, Pages) | Cmd+Option+Shift+V |
| Pasting a value into Excel | Paste Special → Values |
| Pasting a value into Numbers | Edit → Paste and Match Style |
| Pasting a value into Google Sheets | Cmd+Shift+V |
| Stripping formatting manually | Re-copy via TextEdit |
| Repeated workflow, multiple clips | Clipboard manager like ClipHistory |
One More Edge Case: Numbers Copied from PDFs
PDFs are notorious for encoding numbers with invisible formatting characters — especially if the PDF was generated from a spreadsheet. You might copy $1,234.00 and paste what looks like $1,234.00 but actually contains non-breaking spaces or curly quotes around the digits.
If a number you pasted looks right but behaves wrong (a formula won't recognize it, a field rejects it), run it through a plain-text editor first, or use a clipboard manager where you can inspect the raw content before pasting.
Summary
Pasting numbers without formatting on Mac comes down to knowing which tool applies to which context. The built-in shortcut handles most rich-text apps. Spreadsheets need their own Paste Special flows. For anyone who copies and pastes numbers as a regular part of their workflow, a clipboard manager that tracks history and lets you paste clean is the most durable solution — you stop fighting formatting on a case-by-case basis and just paste the value you want.