View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Niek Otten
 
Posts: n/a
Default Divide selected cells by 1000

What a nice addition!

--
Kind regards,

Niek Otten

"Dave Peterson" wrote in message ...
| 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