When I export columns of numbers into excel, then copy and paste into VLOOKUP formulated columns, only one column works. Its as though the numbers in the second column export as text. Not sure how to make sure the second column exports as numbers??
Novice
Windows XP 
Access 2007
When I export columns of numbers into excel, then copy and paste into VLOOKUP formulated columns, only one column works. Its as though the numbers in the second column export as text. Not sure how to make sure the second column exports as numbers??
VIP
Windows 7 64bit Access 2010 32bit
Common topic.
Google: Access export excel numbers as text
Start with http://social.msdn.microsoft.com/For...-form-to-excel
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
Posting Permissions
Reply With Quote