Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Oops - missed a parenthesis:
Num(Value,(If(Value=Floor(Value),'#,##0','#,##0.00'))
Jason
Hmmm,
Try Num(Value,If(Value=Floor(Value),'#,##0','#,##0.00'))
Hope this helps,
Jason
Oops - missed a parenthesis:
Num(Value,(If(Value=Floor(Value),'#,##0','#,##0.00'))
Jason
Thnks Jason,
It's Work.
But Maybe there a way only with format pattern (without If)?
Not that I can think of I'm afraid.