View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Dave Peterson
 
Posts: n/a
Default 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