Formating exported data
 

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 would
like to change all of the numerical data cells to 2 decimal places, but
this can not be done by using "format cells". Any suggestions?


--
GorillaBoze
------------------------------------------------------------------------
GorillaBoze's Profile: http://www.excelforum.com/member.php...fo&userid=5165
View this thread: http://www.excelforum.com/showthread...hreadid=319417

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

Carlos

"GorillaBoze" wrote in message
...

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 would
like to change all of the numerical data cells to 2 decimal places, but
this can not be done by using "format cells". Any suggestions?


--
GorillaBoze
------------------------------------------------------------------------
GorillaBoze's Profile:
http://www.excelforum.com/member.php...fo&userid=5165
View this thread: http://www.excelforum.com/showthread...hreadid=319417

That's what I was looking for. Thanks for the help.

-Chad


--
GorillaBoze
------------------------------------------------------------------------
GorillaBoze's Profile: http://www.excelforum.com/member.php...fo&userid=5165
View this thread: http://www.excelforum.com/showthread...hreadid=319417