View Single Post
  #1   Report Post  
Mark
 
Posts: n/a
Default Rounding numbers to the nearest thousand

Simple question (i hope)

Is there a simple way i can round numbers to the nearest thousand by using
the format cells command.

For example
i would like to display 1,234.56 as 12

I don't want to be diving by 1000 and rounding to zero decimal places
because i still want the whole number displayed in the formula bar when
selecting it.

i use excel 2003

thanx
Mark