12 Replies Latest reply: Aug 17, 2011 2:34 AM by Thanomjit Kiatchavanasawee

# formatting number

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

• ###### formatting number

Hi!

use NUM() Function.

=Num(Fieldname)

Hope this helps.

• ###### Re: formatting number

Forgot to say that Ive tested both Num() and Num# but both generates a error when I load.

Not sure of the english translation but something about "Trash-code after section".

the line looks like this;

Result as Num(GVResult),

the same with Solanki's tips...

• ###### formatting number

Use:

Num(Result) as GVResult,

• ###### Re: formatting number

duh, ofcourse..

Still doesnt help all the way tho.

With just the Num(Result) as GVResult I got no change at all

With the formatting I just gets ##### instead of numbers...

• ###### Re: formatting number

Solanki: I tried both and if I just Fixed to All the numbers got 10 decimals (I only want the ones that needs it to have 10 decimals)

Gupta: Sorry, dont think it would help since its not in english

But its strange that there seem to be a limit with 5 decimals...4 shows OK even without Num()-function.

• ###### formatting number

i want to knw where r u using this field.

if u r using it in pivot or straight table then expand the column containing this field.....becz #### is normally shown when the number contains many digits and thy don't fit in the column.so Expand ur column.

• ###### Re: formatting number

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.

• ###### formatting number

hi!

upload a sample app. in English.

• ###### Re: formatting number

=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

• ###### formatting number

Hi,

If you are using this in Script then you must use in this fasion.

Num(Field_Name,'#,##0.0000000000')  as Field_Name

If you want to use in dimension then just use.

Num(Field_Name,'#,##0.0000000000')

If you want to use in chart then you must go to properties-> number -> and click on expression and click on Fixed to . Here type 10.

Regards,

Kaushik Solanki

• ###### formatting number

Hi,

Try this.

Num(Field_Name,'#,##0.0000000000')

This will allow you to show 10 digits after decimal point.

Regards,

Kaushik Solanki