Number format

[akfruit]

I have a number XXXXXXXXX I want to display this as XXX XXXX XX.

Anyone able to help me then I would appreciate your help.

Thanks in advance

[mr_vodka]

First, Is this a number field? If so, will it always be 9 digits? Will there ever be leading zeros (have to use text field)? Any other info would be great.

[akfruit]

Hi John

This field will always be 9 digits and there will be no leading zeros. It can be a number field but I suppose a text field would be OK as well.

Hope this helps and thanks.

[mr_vodka]

Left ( field; 3 ) & " " & Middle ( field; 4; 4 ) & " " & Right ( field; 2 )

[akfruit]

Thanks for that its works FINE