Formating exported data

G

GorillaBoze

I have a worksheet that contains data that is exported from a program.
The cells that have numerical data in them show up as 2 decimal places
but if you select that cell it is actually 8 decimal places. I woul
like to change all of the numerical data cells to 2 decimal places, bu
this can not be done by using "format cells". Any suggestions
 
C

CarlosAntenna

Tools > Options > Calculation > Precision as displayed
(This cannot be undone.)

Carlos
 
Top