Forum Discussion
Solved
Convert a spreadsheet from thousands to millions
Can anyone tell me how to convert a spreadsheet in which all values were originally entered in thousands back into millions? All entries were originally entered in thousands. No formatting was used ...
- Enter 1000 in a blank cell, then copy (Ctrl+C) that cell, select your number range (select the top cell and press Ctrl+Shift+ArrowDown), paste special multiply (Ctrl+Alt+V,M), press Enter, Esc, and delete 1000 from the cell where you entered that number earlier.
