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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Convert number to text as displayed 3
excel conditional formating decimal fractions 6
Comparing data sets with +/-1 tolerance using conditional formatin 2
Chart Source Data 2
Data labels for charts 1
Peremanently removing decimal places 10
Conditional Formatting Formula Not Working 1
Addition errors with Decimal Places 5

Top