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

--
GorillaBoz
-----------------------------------------------------------------------
GorillaBoze's Profile: http://www.excelforum.com/member.php...nfo&userid=516
View this thread: http://www.excelforum.com/showthread.php?threadid=31941

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

Carlos

"GorillaBoze" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
>
> 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