Forum Discussion

ExcelIsGarbage's avatar
ExcelIsGarbage
Copper Contributor
Jun 25, 2021
Solved

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...
  • PReagan's avatar
    Jun 25, 2021
    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.

Resources