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?
Quoting entire posts clutters the forum and makes threads hard to read !
If you are pleased with a member's answer then use the Star icon to rate it
Click here to see forum rules
No sorry - this was a vba excel query - whoops!
Last edited by arthurbr; 11-25-2011 at 08: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
Quoting entire posts clutters the forum and makes threads hard to read !
If you are pleased with a member's answer then use the Star icon to rate it
Click here to see forum rules
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks