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

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?