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

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.
--
David Biddulph

"NathanG" wrote in message
...
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

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)

"David Biddulph" wrote in message
...
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.
--
David Biddulph

"NathanG" wrote in message
...
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

Superb!

Thanks
"Bob Phillips" wrote:

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)

"David Biddulph" wrote in message
...
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.
--
David Biddulph

"NathanG" wrote in message
...
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