Formatting in Thousands (2000)

[mitjones]

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.

[HansV]

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

[sdckapr]

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

[sdckapr]

<img src=/S/whisper.gif border=0 alt=whisper width=29 height=17>I think you meant a zero (0) not a small "Oh" (o)

Steve

[sdckapr]

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

[HansV]

It is a zero, but I used <!t>

<!/t> and <!t>

<!/t> tags around the format.

[HansV]

Thanks for clarifying that.