View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Marcelo Marcelo is offline
external usenet poster
 
Posts: 1,047
Default Entering large numbers into Excel

hI,

Excel acepts the first 15 digits of the number the next ones will be
replaced by zeros,

for instance 12345678901234567890 will return 12345678901234500000

you can format is as text.

hth
--
regards from Brazil
Thanks in advance for your feedback.
Marcelo



"bl" escreveu:

I am trying to enter this number(110727309194833644) into a cell but Excel
changes the number once I press the Tab key and makes it this
number(1.0727E+17), I need to have the above number in the cell not this
other number. How can I make Excel put the above number in the cell and not
automatically change it?
--
bl