For those struggling with inconsistent full-width and half-width numbers in rosters, here is what I learned after researching Excel's ASC function

When compiling a client roster in Excel, phone numbers and postal codes are sometimes full-width and sometimes half-width ...

When loading Excel, the leading zeros in zip codes and phone numbers disappeared

I have been consulted on this issue after a person in charge pointed out that the leading zeros of zip codes had disappeared ...