| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
More than 15 digits in excel cell it turns them to zeros. Fix?
If you put more than 15 digits an a cell and hit enter, the cell automatical
turns all the digits past the 15th one into zeros. Is there a way to correct this? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
More than 15 digits in excel cell it turns them to zeros. Fix?
Excel can only handle 15 digit numbers.
Hoping that you really need a text string of numeric characters and not an actual number that big.... Either start the entry with an apostrophe ( ' ) OR Format the cells as text before entering <format<cells<number tab....Category: Text Does that help? *********** Regards, Ron XL2002, WinXP "Lisa" wrote: If you put more than 15 digits an a cell and hit enter, the cell automatical turns all the digits past the 15th one into zeros. Is there a way to correct this? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Stop excel from dropping the 0 in the beginning of a number? | Setting up and Configuration of Excel | |||
| Using A Cell In Excel as Criteria for a Query | Excel Discussion (Misc queries) | |||
| Pasting Word table cell with paragraph markers into single Excel c | Excel Discussion (Misc queries) | |||
| How do I force leading zeros in an Excel cell? | Excel Discussion (Misc queries) | |||
| GET.CELL | Excel Worksheet Functions | |||
Hybrid Mode
