Hi Jack

FormatCellsNumberCustom and A000 in the white pane, or A 000 if you
would prefer to have a space between the letter and numbers.
Enter 12 in cell it will display as A012

--
Regards

Roger Govier


"Jack" wrote in message
...
I have the text A012 This is a Test, can i use a custom format to
display in
a cell just A012, the format of the text will always be letter
followed by 3
numbers but i don't want any more letters.

I am sure this is simple but my heads not working today