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
|