How to enter more than 20 digit numbers in one cell

  • Thread starter Prasad.Sakharkar
  • Start date
P

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.
 
R

Ron Coderre

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
 
Top