Divide selected cells by 1000
Yes.
Enter 1000 in an empty cell. EditCopy.
Select your values.
EditPaste Special, check Divide
--
Kind regards,
Niek Otten
"Lowkey" wrote in message ...
|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?
|