I am curious how the apostrophes are still there if you removed them? How did you remove them? Find/Replace?
Tom Farrar
I believe if you convert the data to a table it will eliminate the apostrophes and still keep the data as text.
Patricia Timm
ASKER
Some of the column data are numbers. They are importing them into mysql and I am not sure how the constraints on the database tables are set up. If the excel file passed to us is defining the number columns as text (string) and I am importing them into the database as text (string) ... will this affect the use of these numbers as calculations? If some of the columns in excel are defined as text but are numbers can they still manipulate them for calculations in the database? Thanks in advance