No. of digits accepted in one cell
"Rayaprolu" wrote in message
...
I am trying to enter a particular number of 16 digit length (Example:
8312938507652481). This number is being taken as 8312938507652480 in the
excel.
My question is ... is there any limitation in Excel on the number of
digits
that can be entered in one cell.
If it's formatted as a number, Excel works only to 15 digit precision. If
you format it as text it will take the number you put in (and if you then
want to treat it as a number you may have to use various tricks to split the
text into parts which are manageable as numbers).
--
David Biddulph
|