To paste copied Excel cells without their original formatting, copy them, select the destination, then choose Home > Paste > Values. If you need numbers, dates, or codes to be stored as literal text instead, prepare the destination or convert the data to text; pasting values alone does not turn numbers into text. The steps below explain both meanings so you can choose the right result.
What You’ll Need
- A workbook open in Microsoft Excel for Microsoft 365 on Windows, with the cells you want to copy.
- A destination range large enough for the copied data. If you need to preserve leading zeros or stop Excel interpreting entries as dates, decide which cells must be text before pasting.
- Optional: a spare worksheet or copy of the workbook if you are changing a large or important data set.
Step-by-Step
- Identify what “as text” means for your task. If you want the copied result but not the source formulas, colors, borders, or number formats, use Paste Values. If you need the actual contents stored as text—for example, product codes such as 00421 or an entry such as 3-4—use a text-specific method in the steps below. These are different outcomes: a cell can display 00421 while still containing the number 421, and a value pasted without formatting can still be a number.
- Copy the source cells. Select the cell or range, then press Ctrl+C on Windows. You can also right-click the selection and choose Copy. For a whole row or column, select its heading before copying. The moving dashed border indicates that Excel has copied the selection. Avoid copying entire rows or columns if you only need a small data range, as that can make it harder to select the destination accurately.
- Select the top-left destination cell. Click the first cell where the pasted result should appear. Excel fills the cells to the right and below using the shape of the copied range, so check that the destination area is clear. If the destination overlaps the source, choose a different location or copy the source to another sheet first.
- Paste the results without the source formatting. On the ribbon, choose Home > Paste > Values. In the Paste gallery, select the Values option, commonly shown with a clipboard and “123.” This pastes the displayed results of formulas as fixed values and leaves the destination’s existing formatting in place. It does not paste the source formulas or the source cell formatting. The source cells are unchanged.
- Use Paste Special when you want a dialog. With the copied cells and destination selected, choose Home > Paste > Paste Special, select Values, then select OK. On Windows, Ctrl+Alt+V opens the Paste Special dialog; choose Values and confirm. This route is useful when the Paste gallery is crowded or when you want to check the precise paste option before applying it. In Excel for Mac, use Edit > Paste Special or Control+Command+V to open the Paste Special choices; the available options can vary with the copied content.
- Check what Excel put in the cells. Click a pasted cell and look at the formula bar. A pasted formula result should appear as a value rather than a formula beginning with an equals sign. To confirm whether a code is text or a number, check its alignment only as a clue—alignment can be changed—and try selecting the cell and looking at the Number Format box on Home. Text is shown as Text; numeric values may use General or a number format. For a more reliable test, use an operation suited to your data rather than relying on appearance alone.
- For text copied from another app, use Keep Text Only if available. Copy the text from the source program, select the destination in Excel, and open Home > Paste. If the gallery offers Keep Text Only, select it to avoid bringing across the source styling. The option shown depends on the clipboard contents and source application, so it may not appear for every copy. Pasting plain text strips formatting, but Excel can still interpret entries such as dates or numbers; use a text-formatting method as well when that interpretation would be a problem.
- To retain leading zeros or prevent conversion, set up text handling. For a small number of entries, select an empty destination cell, choose Home > Number Format > Text, and then type the entry. For pasted data, try formatting the destination as Text before pasting plain text, then inspect a few cells. When the source is Excel cells containing numbers, ordinary Paste Values may retain numeric values despite the destination format. For a dependable conversion of already pasted data, use the Text to Columns method in the next step.
- Convert a pasted column to text with Text to Columns. Select the column or range, choose Data > Text to Columns, select Delimited, and choose Next. Clear delimiter selections if the values should remain in one column, then choose Next. In the preview, select the column and set Column data format to Text; choose Finish. Check the results, especially if your data contains commas, tabs, or other characters that could act as delimiters. This method is useful for codes and numeric-looking entries, and selecting Text before Excel parses the data can preserve leading zeros that might otherwise be lost.
- For an existing numeric range, make text results in a helper column. If the values are already in A2:A20, enter
=A2&""in B2 and fill it down. For example, if A2 contains the number 421, B2 returns the text string 421. The formula will not restore zeros that were already removed from the original value. When the results look right, copy the helper cells and choose Home > Paste > Values over the destination if you need fixed text rather than formulas. Keep the original column until you have checked the converted results.
Common Mistakes
- Assuming Paste Values means “convert to text.” It means paste values instead of formulas and formatting. Numbers remain numbers, and dates remain date serial values with whatever display format the destination applies.
- Formatting existing numbers as Text and expecting them to change. Changing a cell’s number format affects how Excel displays the value; it does not automatically change a number already stored in that cell into text. Convert the contents with Text to Columns or a helper formula instead.
- Using regular Paste by accident. Ctrl+V usually brings the source formatting and, for copied formulas, the formulas themselves. Choose the Values option specifically when you want fixed results without source styling.
- Overwriting data below or beside the target. A copied multi-cell range fills an area, not just the cell you clicked. Check the source selection and clear or move anything in the target footprint before pasting.
- Expecting lost characters to return. If Excel already changed 00421 to 421, formatting the cell as Text cannot infer the missing zeros. Recover them from the original source or use a known code length to rebuild them deliberately.
Tips
- Use Paste Values for a clean, static copy of calculated results, such as a report you are sending to someone who should not receive your formulas.
- Use a dedicated text column for identifiers, account references, postal codes, and other entries that are labels rather than quantities. Arithmetic on these values is generally not the goal.
- When importing a text file, select Data > From Text/CSV and review the preview and data type options before loading. Setting an identifier column to Text during import is safer than letting Excel guess after it has removed leading zeros.
- Test a few representative entries first: a leading-zero code, a date-like string, a long number, and an ordinary word. This quickly reveals whether Excel has changed the data type or display.
- If you only need to remove formatting, not formulas, consider whether the destination already has the number format you want. Paste Values keeps destination formatting, which can be an advantage or a source of confusion.
Troubleshooting
The Values option is missing or unavailable: Make sure you copied cells, rather than only selecting them, and then reopen Home > Paste. Some paste choices depend on the type of content on the clipboard. If you copied from another program, use the options Excel offers for that content or paste into a plain-text editor and copy again; remember that this still does not guarantee Excel will keep numbers as text.
The pasted number displays as a date, or the date changes format: Excel may have interpreted the input or applied the destination’s date format. Undo immediately with Ctrl+Z if the result is wrong. Then prepare the destination as Text and paste the source as text, or use Data > Text to Columns and set the relevant column to Text. Check the formula bar and a sample of the data before continuing.
Leading zeros disappear: This means Excel is treating the entry as a number or the zeros were lost earlier. Undo if possible, set up the destination or import column as Text, and paste or reimport from the original data. If the code has a fixed length and you know that length, you can restore zeros using a suitable format or text conversion, but verify the rule with the data owner rather than guessing.
Formulas appear after pasting: You used regular Paste or a paste option that includes formulas. Undo, then choose Home > Paste > Values. If the result must also be text, convert the pasted results afterward using Text to Columns or a helper formula.
Text to Columns splits a value unexpectedly: Go back and undo, then reopen the wizard and clear delimiters that match characters inside your data. Use the preview to confirm that each value remains in the intended column before choosing Finish.
Frequently Asked Questions
How do I paste without formatting in Excel?
Copy the cells, select the destination, and choose Home > Paste > Values. This removes source formatting and replaces formulas with their current results, while keeping the destination formatting.
Does Paste Values turn numbers into text?
No. It pastes values rather than formulas or source formatting, but numbers generally remain numbers. Use Text to Columns with Column data format set to Text, or convert numeric values with a helper formula when text is required.
How can I paste a number such as 00123 without losing the zeros?
Make sure Excel receives it as text before it interprets it. Format the destination as Text before entering or pasting plain-text data, or import the file and set that column to Text. If the zeros have already disappeared, retrieve the original value or apply a verified fixed-length rule.
Can I paste text only from Word or a web page?
Yes. Open Home > Paste and choose Keep Text Only if Excel offers it for the copied content. The option can vary by source. If it is absent, paste through a plain-text editor to remove styling, then check whether Excel has interpreted any numbers or dates.
What is the Windows shortcut for Paste Special?
Ctrl+Alt+V opens the Paste Special dialog in Excel for Windows. Select Values and confirm. On Mac, Control+Command+V can open Paste Special; the menu route is Edit > Paste Special.
Will pasting values change my original cells?
No. Copying and pasting values changes the destination, not the source. If you convert the source itself or overwrite cells, use Undo promptly if needed and keep a backup before making broad changes.
Related
- How to Insert a Line in a Word Header Step by Step
- How to Insert a Line in a Word Table: Step by Step
- How to Insert a Line Between Columns in Microsoft Word
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- Delete a Blank Page in Word: A Simple Step-by-Step GuideTo delete a blank page in Word, show formatting marks with Ctrl+Shift+8 on Windows or Command+8 on Mac,…
- Google Sheets: How to Freeze the Top Two Rows on ScreenTo freeze the top two rows in Google Sheets, open the spreadsheet in a web browser and choose…
- Record Audio in PowerPoint: A Practical GuideYes. In Microsoft PowerPoint for Microsoft 365 on Windows, record narration for slides from the Record tab using…
- Delete an Unwanted Page in Word: Simple FixesTo delete an unwanted page in Word, remove the text or objects on it, or delete the page…
- Custom Number Format Excel Shortcut and How to Use ItIn Excel for Microsoft 365 on Windows, select the cells and press Ctrl+1 to open Format Cells, then…
- Excel Conditional Formatting: No Cells Were Found?In Excel for Microsoft 365 on Windows, “No cells were found” usually means Go To Special could not…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.