Howdy,
I have a MySQL database that I'm pulling several columns into a spread
sheet using the MS Query feature.
One of the columns is a phone number column. Unfortunately, the
database has this column as TEXT and not numeric. So, when I try to get
Excel to apply a Phone Number mask to the column, none of the data shows
up with the phone number mask.
For example, in the database, all phone numbers are entered without
formatting: 2125556234
I'd like Excel to display this column as (212) 555-6234, but it doesn't.
Best guess is because the data is stored as TEXT.
So, is there a way in the query or in the spread sheet to convert all
data in from this column to be stored in the spreadsheet as NUMERIC?
Thanks, Mike
Bookmarks