If you use a leading apostrophe instead, or pre-format the cell for TEXT,
then only your input characters would show in the cell and the
printout.........

Vaya con Dios,
Chuck, CABGx3


"jedi" wrote in message
...

CLR Wrote:
I would try entering a leading apostrophe to input the value as
TEXT..........then if it took it ok, convert it to a number if needed.

Vaya con Dios,
Chuck, CABGx3



"jedi" wrote in
message
...

Hi i am pretty new to excel but here goes. The problem I am having
is
when I try to input a 12 digit number into an excel cell i get
*1.03001E+11 *instead of 1*03000568221* 10 digits seem to go in ok.
I
copy and paste this 12 digit number. any ideas what this can be
thanks
in advance.


--
jedi

------------------------------------------------------------------------
jedi's Profile:
http://www.excelforum.com/member.php...o&userid=35538
View this thread:
http://www.excelforum.com/showthread...hreadid=553009



Hi i put a commer infront of the digits and it now displays the whole
12 digit number with the commer however. This is better that what I had
thou, thanks again


--
jedi
------------------------------------------------------------------------
jedi's Profile:
http://www.excelforum.com/member.php...o&userid=35538
View this thread: http://www.excelforum.com/showthread...hreadid=553009