Forum Discussion
tristaanogre
13 years agoEsteemed Contributor
no... you need to add the preceding apostrophe to all numeric fields. There is no succeeding apostrophe.
In Excel, preceding a numeric value with the apostrophe character tells excel to treat that field as text instead of numeric. You need to do this for all values in your zip-code column that are pure numeric values.
so, if a cell has the value of 12345, put an apostrophe before it (literally, '12345)
If a cell has the value of 12345-1234, no need to do anything because Excel is "smart" and knows that's not a number.
For relevant reading, here's a quote from the TC help documentation (http://smartbear.com/support/viewarticle/11916/):
In Excel, preceding a numeric value with the apostrophe character tells excel to treat that field as text instead of numeric. You need to do this for all values in your zip-code column that are pure numeric values.
so, if a cell has the value of 12345, put an apostrophe before it (literally, '12345)
If a cell has the value of 12345-1234, no need to do anything because Excel is "smart" and knows that's not a number.
For relevant reading, here's a quote from the TC help documentation (http://smartbear.com/support/viewarticle/11916/):
In order for the data provider to treat spreadsheet data correctly, all data in each column (except the column name) needs to be the same type, for example, text only or numbers only. This is because the provider applies only one type to the whole column, so if it contains data of several types some data may be treated incorrectly.
- vx7 years agoOccasional Contributor
Thank you, it worked.