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

LISTNUM + Mail Merge + INCLUDETEXT : Referencing Paragraph # Can't get to work 0
Excel does not accept text format! 0
Creating a Search using a combo box and then creating a report. 4
Varied accuracy custom number formats 3
Autonumber field in Excel that behaves the same as Access 0
Size & Position precision 0
My custom number list doesn't seem to save? 1
Custom Number Format for text 13

Top