I have phone numbers in a column, I am adding a country code and then writing these to a txt file - however I get 3.54E+11 instead of the full number. How can I force these to be written as the 'real' number to the text file. Thanks
I have phone numbers in a column, I am adding a country code and then writing these to a txt file - however I get 3.54E+11 instead of the full number. How can I force these to be written as the 'real' number to the text file. Thanks
Hi and welcome to the board
You posted in an Access forum. is this correct?
No sorry - this was a vba excel query - whoops!
Last edited by arthurbr; 11-25-2011 at 09:19 AM. Reason: Thread moved
In answer to your question , when adding a country code ( don't know how you do it), you could add an apostrophe before this code, turning it to text
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks