manipulating number formats

[Billy]

Hi

If I type in $1,238,000 I want the cell to display $1,000.
Similarly if I type in $15,965,945 I want the cell to
display $16,000. Can I do this without using the round
function?

Thanks

 

[Jim]

I do not believe you can if you are using ws functions.

 

[Anders S]

Billy,

I can do it with a custom number format. The problem is that I don't have a US version of Excel so I can't say exactly what format to use. Decimal and thousands separators are different between versions.

You can start with a custom format like
$#,,"000"
or maybe
$#.."000"
I'm not sure,
and do some experimenting in the Format Cells dialog box (you also have to insert the thousands separator). Also see Excel Help where there are some examples.

HTH
Anders Silvén

 

[Guest]

Thanks Anders - it worked a treat!!

-----Original Message-----
Billy,

I can do it with a custom number format. The problem is

that I don't have a US version of Excel so I can't say
exactly what format to use. Decimal and thousands
separators are different between versions.

You can start with a custom format like
$#,,"000"
or maybe
$#.."000"
I'm not sure,
and do some experimenting in the Format Cells dialog box

(you also have to insert the thousands separator). Also
see Excel Help where there are some examples.

HTH
Anders Silvén


"Billy" <[email protected]> skrev i

meddelandet news:[email protected]...