I'm exporting Access query results to Excel format and one row of numbers is coming in with a ' in front of each number. The character isn't recognized when I use a mid() formula to try and get rid of the ' character. Any suggestions on how to get this data to pull in without this apostrophe symbol in front of my data?
Comment