MS Excel - How do I display a number such as 12,000,000 as 12,000 by custom format? - why is number 12 displayed on alabama football helmet
I would like separated by commas every three digits, but I want to cut up to 1000, so I want 12 million, is about 12 miles.
Thanks
2 comments:
Its easy. Highlight the cell you want to format (or the row or column).
Select Format Cells
Go to the Number tab
Select Custom in the Category
Now type: field, enter the following:
#, # # 0,
Thus billion and will retain their separate and
I like that I use Excel all the time --
Go to Format - Cells - The numbers - the
Scan before you if you do not want to set a new one to suit your needs.
Post a Comment