| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
TEXT() function problem in Excel 2002
In a cell i am using the formula TEXT(0.000000006036,"0.000e-9")
If I enter =TEXT(0.000000006036,"0.000e-9"), it gives "#VALUE!" But if I use =TEXT(0.000000006036,"0.000E-9") it gives correct value as 6.036E-9. I guess 'e' was not handled. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
TEXT() function problem in Excel 2002
It's apparently a bug in some versions of XL. Lowercase "e" works fine
in MacXL04. In article , "Boopathi" wrote: In a cell i am using the formula TEXT(0.000000006036,"0.000e-9") If I enter =TEXT(0.000000006036,"0.000e-9"), it gives "#VALUE!" But if I use =TEXT(0.000000006036,"0.000E-9") it gives correct value as 6.036E-9. I guess 'e' was not handled. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel 2002/2003 problem | Excel Discussion (Misc queries) | |||
| Help to build a Look Up Function or What Ever Function Excel 2002 | Excel Worksheet Functions | |||
| PasteSpecial problem in Excel 2002 | Excel Programming | |||
| Problem with Excel 2002 | Excel Programming | |||
| problem in excel 2002 and windows xp | Excel Programming | |||
Linear Mode
