change the format of a number

[Anonymous]

hello i am trying to change the format of column which contains numbers

as shown in the box

2.35E+20

can anyone tell how to change the format to normal format ?

[#2]

Hi Tamer,

In chart/table 'Properties' go to 'Number' tab.

Choose your expression on the left and apply the number format settings you wish.

Hope this helps.

Kind regards,

Nuno

[manas_bn · Accepted solution]

I think this should work:

Num(Num#(YOUR_FIELD_NAME))

For your example, Qlikview will still show 2.35+e020, but it will be stored as a number.

Cheers!

[jagan]

Hi,

Try like this

=Num(Num, '###0.##')

This will round off to 2 decimal points and show you as a normal number.

Regards,

Jagan.

[Anonymous]

it's working thank you very much

[Anonymous]

it's working thank you very much