fixed decimals

Is there a formula I can use to fix decimals on values already on a
spread***? I am importing data from a database that assumes 4 decimal
places, so a 70000 is really 7.0000. I tried using the fixed formula but
that did not give me the desired result. I also went to Tools -> Options ->
Edit -> Fixed Decimal Places and set to 4 but that only helps for newly
entered data. Please help!

Thank You!

--GREG--
.

Loading