ExcelBanter - TEXT() function problem in Excel 2002

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - TEXT() function problem in Excel 2002 (https://www.excelbanter.com/excel-programming/342885-text-function-problem-excel-2002-a.html)

Boopathi

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.

JE McGimpsey

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.

All times are GMT +1. The time now is 01:36 PM.