Format a number

[qvhjenvo]

Hi,

I have a number for ex. 4,535910775293e-014

I want to format the number to for ex. 0,05. How?

Someone helps me!

Loi

[MK_QSL]

Click on Use Advance Editor  (Right TOP) where we are replying....!

Now you can find Attach (Right Bottom)

[its_anandrjs]

Use advance editor for that.

[qvhjenvo]

Ok. Thanks

In the attachement there are 3 textbox with different formats.

Result in the last one is desired.

The first textbox is what I want to format directly so that I have as the result in the last txtbox.

[MK_QSL · Accepted solution]

=NUM($(expUSDEksponeringTeller)/$(expBeløpNyePoliser)*POW(10,12),'#,##')

Update :

or

OR

=NUM($(expUSDEksponeringTeller)/$(expBeløpNyePoliser)*POW(10,RIGHT(SubField($(expUSDEksponeringTeller)/$(expBeløpNyePoliser),'e',2),2)-1),'#,##')

[qvhjenvo]

Thanks. U saved my day!!!

[#7]

Hi Loi Tan Vo,

There is yet another way of making, using integers only might use a Num(Field, '########################').

Hope that helps.

I left an example here Campo numérico com mais de 14 caracteres

hugs