| Home |
| Search |
| Today's Posts |
|
#2
|
|||
|
|||
From the Help file: Excel's limit is 15 digits of precision.
"Bill" wrote: I have a spreadsheet with long numbers formatted as text (16 digits). When I convert them to numbers the resulting numbers has the first 15 digits correct and the rest are zero's. Can someone explain what is happening and if this is a hard limitation? Bill |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| My filter is not working for numbers & text | New Users to Excel | |||
| Format a cell with numbers and user defined text | Excel Discussion (Misc queries) | |||
| Converting text to numbers | Excel Worksheet Functions | |||
| Convert text to numbers | Excel Discussion (Misc queries) | |||
| How to Replace numbers and text with numbers only? | Excel Worksheet Functions | |||
Threaded Mode
