Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
hi
i am facing a situtation in which i have to show upto two values after decimal for a particular row in a pivot table....
if i use num('a','#.#')
it will display all the values after decimal. how can i restrict it to two values only.....
e.g 134.57
Hi,
Try num('a','#.#0')
Regards,
Sokkorn
Num(a,'#,##0.00') should do it.
Hope this helps,
Jason