Issue with num format

[sergio0592]

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

[robert_mika]

=num(sum(Orders),'# ##0')

You need apostrophes..

[Chanty4u]

try to add single quotes  for 

'##0'

[sunny_talwar · Accepted solution]

Try this:

=Num(Sum(Orders), '# ##0', '.', ' ')

[sergio0592]

Great Sunny, as usual !! Solutions suggested by Chanty and Robert return : Number # ##0

I will work on num function, it seems have numerous parameters!