Format the number as #,##0,;-#,##0, or similar. Not the comma at the end -
this tells Excel to display as thousands (two commas here will display as
millions).

Note that 1,234.56 will display as 1 (thousand) not 12.

"Mark" wrote:

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