Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
E+14 error
I have a coulmn with numbers, but they are formatted as text. ESN #s 268435456106743252 But when I format it to numbers, I get the following error: 2.68435E+17 This also creates a problem since this process also zeros out the last three digits: 268435456106743000 (the 252 are now replaced as 000) Does anyone know way to correct this? Thanks in advance! -- moyemrick |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Visual Basic Error Run Time Error, Type Mismatch | Excel Discussion (Misc queries) | |||
Error of slope taking into account error of the data points | Excel Worksheet Functions | |||
Counting instances of found text (Excel error? Or user error?) | Excel Worksheet Functions | |||
I have Error 1919 Error Configuring ODBC dataSource Database | Excel Discussion (Misc queries) |