MS Access 2013.
Data format is Short text and it stores SSN's and TIN's with dashes. Length of string varies between 10 (TIN) and 11 (SSN).
I'd like to have a formula for a new field that strips out the dashes and any leading zeroes and also converts to Number format. Thanks.