manipulating number formats

B

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
 
A

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
 
G

Guest

Thanks Anders - it worked a treat!!
-----Original Message-----
Billy,

I can do it with a custom number format. The problem is
Click to expand...
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
Click to expand...
(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
Click to expand...
meddelandet news:[email protected]...
 
Top