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

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

You will actually have to create your own custom number format, which is
"#,". And yes, 1234,56 will then display as 1. 1501 will display as 2

"Vicar" wrote:

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