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.
|