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