How to enter more than 20 digit numbers in one cell
 

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.

How to enter more than 20 digit numbers in one cell
 

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


"Prasad.Sakharkar" wrote:


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.




--
Prasad.Sakharkar

How to enter more than 20 digit numbers in one cell
 

From
http://office.microsoft.com/en-us/ex...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.
--
David Biddulph

"Prasad.Sakharkar" wrote in
message ...

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.
--
Prasad.Sakharkar