advanced excel ms training - Reformat postcodes

Hi Christina

Thanks for your question.

I think you would need to set a custom format for this. There are various symbols that you can use as part of a custom format (as you will see if you go to Format - Cells - Number and select Custom from the Categories list).

I would suggest going to Excel Help and looking up custom number formatting to find out what all the various symbols stand for then create you own custom number format for the postcodes.

I hope you enjoyed your training today and have a good weekend.
Amanda