Number Format

[matancha]

Hello All.

I have field with 2 numbers: 1.5625 , 3

I want to display them (Straight Table atc...) like: 1.56, 3 (And NOT 3.00, I try - '#,##0.##' )

How can I do that? Which format I need?

Thks for your help -

Matan

[Jason_Michaelides]

Hmmm,

Try Num(Value,If(Value=Floor(Value),'#,##0','#,##0.00'))

Hope this helps,

Jason

[Jason_Michaelides · Accepted solution]

Oops - missed a parenthesis:

Num(Value,(If(Value=Floor(Value),'#,##0','#,##0.00'))

Jason

[matancha]

Thnks Jason,

It's Work.

But Maybe there a way only with format pattern (without If)?

[Jason_Michaelides]

Not that I can think of I'm afraid.