To paste into a spreadsheet without breaking its format, paste values only instead of a normal paste. In Google Sheets press Command+Shift+V. In Excel use Paste Special → Values. In Numbers use Paste and Match Style. For leading zeros and date mangling, set the destination cells to Text before you paste.
Almost every broken spreadsheet paste is one of two different problems, and the fix for one makes the other worse. Either the formatting came along (fonts, fills, a web page’s table styling), or the spreadsheet interpreted your data (dates, stripped zeros, scientific notation). The first is solved by what you paste. The second is solved by how the destination cell is set up before you paste. This guide separates the two so you can match the symptom to the right fix.
| What you see | Real cause | Fix |
|---|---|---|
| Pasted cells have a different font, background or borders | The clipboard carried rich formatting (RTF/HTML) from the source | Paste values only, or plain text |
| Leading zeros disappear (ZIP codes, IDs) | Destination cell is General, so the value is read as a number | Format as Text before pasting |
| 3/4 or 1-2 becomes a date | Auto-detection of date-like strings | Format as Text before pasting |
| Long numbers show as 1.23E+15 or lose digits | Excel keeps about 15 significant digits for numbers | Format as Text before pasting |
| Everything lands in a single cell | Source isn’t tab-delimited, or the paste went into one cell in edit mode | Exit cell edit mode, then split with Text to Columns |
| Rows land in one cell with line breaks | Source cell contained newlines inside quotes | Check the source; use Find and Replace on line breaks after pasting |
| Numbers are left-aligned and won’t sum | Stored as text | Convert to number, or re-paste into General cells |
| Pasted data overwrote conditional formatting or validation | A full paste replaces cell formats and validation rules | Paste values only |
Copy, select the destination, and press Command+Shift+V. This pastes values only. The right-click menu offers the same under Paste special, along with « Formatting only » and « Formulas only ». If you want the opposite, formatting without content, that’s also under Paste special.
Use Edit → Paste Special (or the Paste dropdown on the Home tab) and choose Values. The Paste Special dialog also has « Values and number formats » and « All using source theme », which matter when you want numbers to keep their display format but not the source styling. After a normal paste, the small clipboard icon that appears offers « Match Destination Formatting » and « Keep Text Only ». Both undo the style import without re-copying. Excel’s keyboard shortcuts for Paste Special differ between versions and keyboard layouts, so confirm the one you want in the Edit menu rather than trusting a cheat sheet.
Numbers has Edit → Paste and Match Style, which drops the source styling and adopts the destination’s. If you’re copying formula cells, Paste Formula Results pastes the calculated values instead of the formulas. Both live in the Edit menu, so you can read the current shortcuts straight from there.
Values-only paste doesn’t help when the spreadsheet itself rewrites the content. That happens at paste time, based on the destination cell’s number format. The order of operations is the whole trick: format first, paste second. Formatting after the fact is too late, because the conversion already happened (the original zero in 00123 is gone, and reformatting the cell as Text won’t bring it back).
This also protects long numeric IDs such as 16-digit order numbers, since text isn’t subject to the roughly 15-digit precision limit Excel applies to numbers. It protects gene-name-style identifiers and anything that resembles a date, like 3/4 or 1-2.
Text-formatted cells can’t be summed or averaged directly, and sorting treats « 100 » as coming before « 9 ». Use Text format for identifiers (things you look up, never calculate). For quantities, keep General or Number, and clean the data at the source instead.
If a column is left-aligned and SUM returns 0, the values are text. In Excel, select the cells and use the warning icon’s « Convert to Number » option, or multiply the range by 1 using Paste Special → Multiply. In Google Sheets, a formula like =VALUE(A2) in a helper column works, then paste its values over the original.
Spreadsheets split pasted text into columns on tabs and into rows on line breaks. Text copied from a web page table or another spreadsheet carries tabs, so it spreads out correctly. Text copied from a document, chat or terminal often uses spaces or commas instead, so it all lands in one cell.
Two common causes and fixes:
The cleanest workflow for messy sources is to avoid pasting rich content at all. A clipboard manager changes the economics of that: instead of copying again after a bad paste, you re-paste the same history item in a different way.
Maccy is a free, open-source, local-first clipboard manager for macOS, and it fits this workflow in a few concrete ways:
One honest limitation: a clipboard manager doesn’t fix the destination cell’s format. Leading zeros and date conversion are still decided by the spreadsheet, so the « format first, paste second » rule applies no matter how you paste.
Use Paste Special and choose Values (or Keep Text Only from the paste options icon). This inserts the content and leaves the destination cell’s fonts, fills and number format untouched.
Press Command+Shift+V. It pastes only the values, without the source formatting.
Cells formatted as General treat 00123 as a number and store it as 123. Format the destination cells as Text before pasting to keep the zeros.
Spreadsheets auto-detect values that look like dates, such as 3/4 or 1-2, and convert them. Formatting the destination range as Plain text or Text before pasting prevents the conversion.
Yes. Maccy app can paste without formatting, and it keeps your clipboard history so you can re-paste the same item as plain text after a bad paste.
Formatting problems are solved by what you paste, and data-conversion problems are solved by how the destination is set up. Paste values when the source is rich, and set cells to Text before pasting anything that’s an identifier rather than a quantity. Do both and the « why did my spreadsheet change my data » problem mostly disappears.
If you paste between apps all day, Maccy mac is a free, no-account way to keep a searchable history and re-paste as plain text when a paste goes wrong. What’s the messiest source you regularly paste into a spreadsheet: web tables, PDFs, or exports from another tool?
