Hi All,
I am using Office XP.
I want to convert a text value to scientific notation form.
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 properly.
Can any one of you give your input.
Kindly send your reply to
Thanks
P.Boopathi
--
boopathi
------------------------------------------------------------------------
boopathi's Profile: http://www.excelforum.com/member.php...o&userid=27976
View this thread:
http://www.excelforum.com/showthread...hreadid=474831