Convert a string to a formatted string

[FB1]

Hi

I have a String field for the NHS no

I wish to format it to the following ### ### ####

I know I need to do this as a formular anyone got any ideas

Thank you for all your tiem

Ralph

 

[briangriffin]

picture({NHS_No},"xxx xxx xxxx")

This function requires a string input, so if your database stores the NHS number as a number you'll have to convert it.

 

[FB1]

Hi Brian

Thank you very much, as soon as I had posted the post, I remembered how to do it.
Ralph

But thank you ever so much