SOLVED

Excel Keeps Changing the format of my cells

Copper Contributor

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 leading 0(s). How do I stop this from happening? 

3 Replies
best response confirmed by allyreckerman (Microsoft)
Solution
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.
Thank you.
You're welcome!
1 best response

Accepted Solutions
best response confirmed by allyreckerman (Microsoft)
Solution
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.

View solution in original post