PSFS Family Directory - Family List: How to remove apostrophe from postal code with leading zero in excel

When exporting a Family List to Excel, Postal Codes with leading zeros may have an apostrophe in front of the first digit (0). 

  1. In Excel, do a find and replace on the postal code column to replace apostrophe with nothing. 
           
  1. Next, highlight the Postal code column, right-click the column and select format cells... (below left).
                                           
  1. Select Custom and select 0 option (above right)
  2. Enter 5 zeros directly under the word Type in that field (above right). 
  3. Click OK. The postal codes should display as normal.

Updated

Was this article helpful?

0 out of 0 found this helpful

Have more questions? Submit a request