Custom number format

J

Jack Schitt

I have a number that is rounded to the nearest 1000.
I want the number displayed in thousands, ie so that if the underlying
number is 123000 it should be displayed as 123.

I realise that I could divide the number by 1000 and display it normally but
I am reluctant to do that if there is a simple formatting solution.

Help?? thanks
 
G

Guest

If you go to format cells and number > custom put

_-* #,k

in and this should solve your problem. The 'k' is
optional. This will keep the true value ie 123000 if you
do any calculations on the number.

HTH

John
 

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

Varied accuracy custom number formats 3
How do I round a number to the nearest thousand in Excel??? 3
Custom Number Format for text 8
How to display the value in different format? 7
A non roundup decimal place cell format 6
How to programmatically add a non standard custom cell format 12
Custom Format on 16 Digit Number 5
Custom Number Formats 8

Top