Forum Discussion
ExcelIsGarbage
Jun 25, 2021Copper Contributor
Excel Keeps Changing the format of my cells
I'm working with numbers that start with a leading 0 and I've formatted my cells as "Numbers" then "Text." I copy and paste a number from Word and Excel changes the format of the cell and removes the...
- Jun 25, 2021Hello ExcellsGarbage,
After pasting the data from Word to Excel, select the paste options dropdown and choose Match Destination Formatting. You can also use the shortcut Ctrl then M (separately) after pasting the data.
ExcelIsGarbage
Jun 25, 2021Copper Contributor
Thank you.
PReagan
Jun 25, 2021Bronze Contributor
You're welcome!