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