TEXT() function problem in Excel 2002

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Using scientific notation in TEXT() function 1
Time Calculations Help 4
Auto update/fill column heading 4
for each in a range 1
Macro to Edit Contents of Cell 4
Need urgent help 0
Weighted randbetween text list 3
Why do I have to restart Excel when ActiveSheet.QueryTables.Add fails? 2

Back
Top