| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Forcing a postcode in Excel 2003
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| forcing date to excel | Excel Worksheet Functions | |||
| M25 postcode | Excel Worksheet Functions | |||
| postcode | Excel Discussion (Misc queries) | |||
| HELP WITH POSTCODE FORMATTING | Excel Worksheet Functions | |||
| GIS mapping / routing / driving / addressing / postcode information in Excel | Excel Programming | |||
Threaded Mode
