rounding figures to nearest thousand

[NathanG]

Hi,

I have financial data that is shown to the nearest penny. I need to change
any figures by rounding them to the nearest thousand. I have looked at using
the round function or setting up a custom text format.

If the round function is the way to go how can I enter formula into a field
which doesn't delete the data already in it?

Thanks

Nathan

 

[David Biddulph]

If you put a formula into a cell, then it *will* delete the data already in
it.

If your cell has a formula =A1+B2, then you can replace that formula by
=ROUND(A1+B2,-3)
Otherwise if your formula is in cell C2 and you don't want to change C2, you
can put your rounded figure in D2, using =ROUND(C2,-3) , and this same
formula will work if you've got a number, rather than a formula, in C2.

 

[Bob Phillips]

If you just want to show it in thousand, just use a format of #,##0,

--
HTH

Bob Phillips

(there's no email, no snail mail, but somewhere should be gmail in my addy)

 

[NathanG]

Superb!

Thanks

If you just want to show it in thousand, just use a format of #,##0,

--
HTH

Bob Phillips

(there's no email, no snail mail, but somewhere should be gmail in my addy)