Divide selected cells by 1000
Or maybe keep the value, but give the cells a custom format of:
#,
(end with a comma)
Lowkey wrote:
I have a spreadsheet with all values in $ and I need to convert it to
thousands ($K). Is there a way I can simply enter 1000 in a cell on my
spreadsheet, select all the values and divide them all by that cell?
--
Dave Peterson
|