Format of a number in a textbox

[#1]

Hey everyone,

In a textbox, I show the result of an expression. I get 55695 and I would like to display 55 695, with a space for the separator for the thousand.

I've tried several things, among them:

= Num (myvalue, '# ##0')

but it doesn't work.

Any ideas ?

Thank you for your help

[swuehl · Accepted solution]

You need to specify the delimiters,too, like

= Num (myvalue, '# ##0','.',' ')

[#3]

Thank you !

[krishna20]

Hi

Hope it helps.

=Num(sum([Annual Salary]),'#,##0')