Select the cells you wish to format........

Right-click FormatCells NumberTab Number set for 4 Decimal
places..........

Vaya con Dios,
Chuck, CABGx3



"GreenThumb" wrote in message
...
Is there a formula I can use to fix decimals on values already on a
spreadsheet? 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--