How to enter more than 20 digit numbers in one cell

[Prasad.Sakharkar]

I want to add just 20 digit number in one cell but whenever I try to
type 13080048062000000030 I get 13080048062000000000

What is the problem ?


Presently I am just putting '13080048062000000030. It just forces it in
text format but I have not solved the original problem.

 

[Guest]

You have 2 options:

You already know one of them
Put an apostrophe (') in front of the number.
That's OK for occasional use.

The other is to set the number format for the range of cells to Text
<format><cells><number tab>
Category: Text......Click [OK]
Now whatever you type in the cells will be interpreted as text, including
numbers and formulas.

Does that help?
***********
Regards,
Ron

XL2003, WinXP

 

[David Biddulph]

From
http://office.microsoft.com/en-us/excel/HP051992911033.aspx?pid=CH062527721033
(or from Specifications and Limits in Excel help):
Number precision 15 digits
Beyond that you need text (as you've discovered), and then use text
manipulation if you need to do calculations.