What do you mean by format cells asks for AA## #AA? How are you doing this?

--
Regards,
Tom Ogilvy

"Scott" wrote in message
...
Doing a simple spreadsheet with UK postcodes in trying to make it so that
whatever you put in is in a predesigned way. At the moment I have it so
that format cells asks for AA## #AA, but this does not seem to work? I
want
to force capital letters and to force a 0 if the postcode first number is
a
single figure (example if the postcode is ip6 8ly, I want excel to convert
it to IP06 8LY)...

Get my point???

Regards Scott