Large Digit Issues

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

When I try to put a string of 18 digits in a column (similar to this
350001660334434123) the last three digits change to 000 (making the number
350001660334434000), I have change the column to format in 'General' but this
throws up an error message and nothing else seems to give me what I need.
Any help would be appreciated.
 
You have two options:

1. format the cells as Text before entering the values
2. enter an apostrophe as the first character typed
 
Format as text or precede the entry with an apostrophe '
If you look up specifications in help you will see that Excel
has 15 digits of precision and will truncate any digits after that to zero


--


Regards,


Peo Sjoblom
 
Gary''s wrote on Tue, 16 Oct 2007 07:21:00 -0700:

GsS> You have two options:

GsS> 1. format the cells as Text before entering the values
GsS> 2. enter an apostrophe as the first character typed

You might have emphasized that both options produce text ;-)


??>> When I try to put a string of 18 digits in a column
??>> (similar to this 350001660334434123) the last three digits
??>> change to 000 (making the number 350001660334434000), I
??>> have change the column to format in 'General' but this
??>> throws up an error message and nothing else seems to give
??>> me what I need. Any help would be appreciated.

James Silverton
Potomac, Maryland

E-mail, with obvious alterations:
not.jim.silverton.at.verizon.not
 
Back
Top