View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Pred Pred is offline
external usenet poster
 
Posts: 9
Default Dividing multiple cells by 1000

Try formatting your cells like this:
##0,

"Debbie" wrote:

I have a large spreadsheet and want to see the numbers in thousands. Is
there a way to highlight all the cells and divide them all by 1000 without
going into each cell?