View Single Post
  #1   Report Post  
GorillaBoze
 
Posts: n/a
Default 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