Formatting in Thousands (2000)

Topic

New Reply

Hey, I have a spreadsheet with calculated values carried out to the 2nd decimal place. Per my bosses request, he’d like me to display in thousands only. For example, $388,000 displayed as $388.

Can you advise on how to do universally on the spreadsheet as a whole without dividing each individual cell by 1,000???

Thanks.

Reply | Quote

Replies

Set the number format for the cells you want to display thousands to the custom format 0, or #,

Reply | Quote

I think you meant a zero (0) not a small “Oh” (o)

Steve

Reply | Quote

It is a zero, but I used

Code:

 and 

tags around the format.

Reply | Quote

I am sure you realize this, but for the sake of others who might not be aware of the difference:
Be careful with #, Any number <500 will display nothing, while if you use 0, the numbers <500 will display as zero (0).

It depends on what you are after…

Steve

Reply | Quote

Thanks for clarifying that.

Reply | Quote

Select the cells and format cells – numbers(tab) custom:
#,##0,

or even
0,

if you do not want the commas if you go into the millions

Steve

Reply | Quote