It's the social security number for Malta, for example my number is
something like this:

A nnnn nnnn

However there may be variants to this one, because I've seen shorter
numbers. What I know for sure is that there is a letter preceding a couple
of numbers:

A nnn...


where A is a character from A-Z and n is a number. n.. means that the
number of numeric characters is not known.

Hence, for now I'm assuming that if I divide the digit into chunks of
numbers which may be up to 4 characters each.


"Fred Smith" wrote:

We have lots of ideas. But first you have to tell us what's in the cell. The
best way is to give a few examples of the cell's contents and the format you
want to see.

However, formatting is for numbers. If you have text in the cell (like
"first letter"), you can't format text.

Regards,
Fred.

"Jon" wrote in message
...
I would like to update the format of a cell as follows:

first letter + space + next four digits + remaining digits

Any ideas?