Formating numbers

[slribeiro]

Greetings.

I need help.

How can I format a number like num(value,'##0') but with the thousand separator being the character '.

The ideia is to have numbers like 23'456.

Best regards

Simão Ribeiro

[Anonymous]

How about something like this using ascii character 145

=num(left('23456',2),'##')&chr(145)&num(right('23456',3),'##0')

[antoniotiman · Accepted solution]

Try

Replace(Num('23456','#.##0'),'.',Chr(39))

23456 is Your field.

[Anonymous]

Good shout Antonio it should be chr(39)

[slribeiro]

Many thanks.