Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
I'd like format my expression number with separation between thousands . In the chart properties, it works when i put # ##0
But i try to get the same thing with num function, it goes wrong. I try with =num(sum(Orders),# ##0) and i have the message 'Error in expression'.
Regards
=num(sum(Orders),'# ##0')
You need apostrophes..
try to add single quotes for
'##0'
Try this:
=Num(Sum(Orders), '# ##0', '.', ' ')
Great Sunny, as usual !! Solutions suggested by Chanty and Robert return : Number # ##0
I will work on num function, it seems have numerous parameters!