Showing numbers to the nearest thousand

K

kosciosco

I have a sheet full of large numbers and I want to format it just t
show numbers to the nearest thousand without having to divid
everything by 1000 manually.

I've seen it done before but can't remember how.

Any ideas?

Thanks

Simo
 
F

Frank Kabel

Hi
try
=ROUND(A1,-3)
to change the value.
to format these cells use a custom format like
#.
 
D

DDM

Simon, search "Custom Number Format" in Excel 2000's help, and you'll find:

To display 12000 as 12, use this custom number format: #,
To display 12200000 as 12.2, use this custom number format: 0.0,,

The comma is the equivalent of dividing by 1000.
 

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

Cross-reference Insert Default Change 0
Rounding numbers to the nearest thousand 2
Using project as a resource tracker 0
Custom number format 2
Format Round to Nearest Thousand 3
Format - Text to Number or vice versa 1
How do I round a number to the nearest thousand in Excel??? 3
convert number to % using only custom number format challenge 7

Top