Re: how to input a 12 digit number into a cell

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance


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" <jedi.29lhen_1150629003.3708@xxxxxxxxxxxxxxxxxxxxx> wrote in
message
news:jedi.29lhen_1150629003.3708@xxxxxxxxxxxxxxxxxxxxxxxx

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?action=getinfo&userid=35538
View this thread:
http://www.excelforum.com/showthread.php?threadid=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, thats again


--
jedi
------------------------------------------------------------------------
jedi's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=35538
View this thread: http://www.excelforum.com/showthread.php?threadid=553009

.

Relevant Pages

  • Re: how to input a 12 digit number into a cell
    ... Hi i am pretty new to excel but here goes. ... Hi i put a commer infront of the digits and it now displays the whole ...
    (microsoft.public.excel.newusers)
  • Re: how to input a 12 digit number into a cell
    ... Tried that as well it just wont accept numbers over 11 digits long? ... jedi's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=35538 ...
    (microsoft.public.excel.newusers)
  • how to input a 12 digit number into a cell
    ... Hi i am pretty new to excel but here goes. ... copy and paste this 12 digit number. ... jedi's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=35538 ...
    (microsoft.public.excel.newusers)