sawilliams
Technical User
Hello:
I'm cleaning up a ton of data and I've imported a number of Excel spreadsheets into my database. One of the fields is "PHONE" and, after spending a lot of time fixing messy records, I see that many of my phone numbers have taken on some weird formatting. The original field in Excel was "general", not formatted in any particular manner. But here is a sample of what my phone numbers look like in Access:
I can't find anyway to undo this. Looking at the original spreadsheets, the phone numbers appear normal. Any suggestions?
I'm cleaning up a ton of data and I've imported a number of Excel spreadsheets into my database. One of the fields is "PHONE" and, after spending a lot of time fixing messy records, I see that many of my phone numbers have taken on some weird formatting. The original field in Excel was "general", not formatted in any particular manner. But here is a sample of what my phone numbers look like in Access:
PHONE
9084399510
9082420666
9082165186
9.89772e+009
9.78887e+009
9.7876e+009
9.78749e+009
9.78665e+009
9.78545e+009
9.78462e+009
9.73994e+009
9.73994e+009
9084399510
9082420666
9082165186
9.89772e+009
9.78887e+009
9.7876e+009
9.78749e+009
9.78665e+009
9.78545e+009
9.78462e+009
9.73994e+009
9.73994e+009
I can't find anyway to undo this. Looking at the original spreadsheets, the phone numbers appear normal. Any suggestions?