Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
No. of digits accepted in one cell
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. Thanks in advance. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
No. of digits accepted in one cell
Excel, like nearly all computer software, uses IEEE Double
Precision Floating Point Number, which are limited to 15 digits of precision. Anything beyond that is rounded. If you don't intend to do arithmetic on the number, (e.g., it is a phone number or a credit card number), format the cell as Text prior to entering the number, or precede the number with an apostrophe. The apostrophe will not show in the cell but will in the formula bar. See www.cpearson.com/excel/rounding.htm for more information. -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "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. Thanks in advance. |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
No. of digits accepted in one cell
See Help for "Specifications" for a list of Excel's limitations. Otherwise,
the previous replies are correct and complete. Jerry "Rayaprolu" wrote: 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. Thanks in advance. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Compiling macro based on cell values | Excel Discussion (Misc queries) | |||
Instead of a negative number, I'd like to show zero... | Excel Worksheet Functions | |||
copying cell names | Excel Discussion (Misc queries) | |||
cell color index comparison | New Users to Excel | |||
up to 7 functions? | Excel Worksheet Functions |