Rounding numbers to the nearest thousand

G

Guest

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
 
G

Guest

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.
 
G

Guest

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Format cell to the nearest 100 4
Rounding to the nearest 50 cents 4
rounding down to nearest 1/32 3
Round to nearest thousand 3
Showing numbers to the nearest thousand 4
Rounding to the nearest cent...currency values 3
rounding up to nearest specified whole number 1
Rounding to the Nearest Eighth 4

Top