How to remove apostrophe before zeros '0

Adarian Searcy

Good afternoon,

I have a column documenting various Zip Codes uploaded from an excel sheet. I performed a =trim on the excel prior to uploading into Smartsheet. All of my zip codes ranging 1-9 do not have an apostrophe. However the zip coding beginning with 0 have one.

I've tried to manually delete the apostrophe only and manually delete the entire zip and reenter but the apostrophe returns.

Any assistance is greatly appreciated.

Paul Newcome

This will always happen when a number has a leading zero.