formatting number

[t_hylander]

Ive got a couple of numbers ranging from 0.1 to 0.00001 in a excel-file. They are not formatted as numbers (due to the range).

I dont  want the numbers to with a fixed format (0.10000 to 0.00001).

How can I deal with this in QW?

It works now with 4 decimals but with 5 it shows 4,6e-005 (0.00046).

Thanks in advance!

[t_hylander]

you were partly right

I didnt expanded it enough when I tested it earlier.

BUT it didnt help much because the numbers look like this now (its a straight table).

0,000.0000000000  (using Num(Result,'#,##0.0000000000')

and 4,6e-005 without format.

[rahulgupta]

hi!

upload a sample app. in English.

[thanomjit]

Please , try 

=num(0.00046)/if(Len(Right(0.00046*10000,index(0.00046*10000,'.')-1))=1,10,1)     result 4.6 E-005

=num(0.0004)/if(Len(Right(0.0004*10000,index(0.0004*10000,'.')-1))=1,10,1)     result 0.0004

[thanomjit]

Please , try 

=num(0.00046)/if(Len(Right(0.00046*10000,index(0.00046*10000,'.')-1))=1,10,1)     result 4.6 E-005

=num(0.0004)/if(Len(Right(0.0004*10000,index(0.0004*10000,'.')-1))=1,10,1)     result 0.0004