Excel Keeps Changing the format of my cells

New 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)
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!