| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Converting text to numbers
Where would I get an add-in for this?
"Gary's Student" wrote: Excel can only handle very small numbers. Less than 16 digits There are commercial add-ins available to address this limitation -- Gary's Student "Sara" wrote: I had a 16 digit number in excel stored as text. When I convert it to a number the last digit becomes a zero. Is there anyway that I can fix this? |
|
#2
|
|||
|
|||
|
Sara,
What do you want to do (math-wise) with the sixteeen digit number? HTH, Bernie MS Excel MVP "Sara" wrote in message ... Where would I get an add-in for this? "Gary's Student" wrote: Excel can only handle very small numbers. Less than 16 digits There are commercial add-ins available to address this limitation -- Gary's Student "Sara" wrote: I had a 16 digit number in excel stored as text. When I convert it to a number the last digit becomes a zero. Is there anyway that I can fix this? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| about converting numbers to text. | Excel Discussion (Misc queries) | |||
| Cells formated as numbers are calculating like text | Excel Discussion (Misc queries) | |||
| Concantenate Text with numbers with fixed form | Excel Worksheet Functions | |||
| how to format numbers stored as text or vice versa to use vlookup | Excel Worksheet Functions | |||
| converting numbers to text and prefill text field with 0's | Excel Discussion (Misc queries) | |||
Linear Mode
