Large Digit Issues
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. |
Large Digit Issues
Put apostrophe in front, Excel only retains 15 significant digits of a
number. Sorehead wrote: 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. |
Large Digit Issues
You have two options:
1. format the cells as Text before entering the values 2. enter an apostrophe as the first character typed -- Gary''s Student - gsnu200750 "Sorehead" wrote: 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. |
Large Digit Issues
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 "Sorehead" wrote in message ... 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. |
Large Digit Issues
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 |
All times are GMT +1. The time now is 09:31 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com