By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,952 Members | 1,616 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,952 IT Pros & Developers. It's quick & easy.

Access Export to Excel puts ' in front of numbers, how do I get rid of this?

P: 34
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?
Aug 27 '14 #1
Share this Question
Share on Google+
1 Reply


P: 34
nevermind! solved it myself!
Aug 27 '14 #2

Post your reply

Sign in to post your reply or Sign up for a free account.