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.
PReagan
Jun 25, 2021Bronze Contributor
Hello 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.
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.
- PReaganJun 25, 2021Bronze ContributorYou're welcome!