Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
How about something like this using ascii character 145
=num(left('23456',2),'##')&chr(145)&num(right('23456',3),'##0')
Try
Replace(Num('23456','#.##0'),'.',Chr(39))
23456 is Your field.
Good shout Antonio it should be chr(39)
Many thanks.