A co-worker is currently using an Access database to download data from a webpage. Once this data is loaded into a temporary table, it is copy/pasted (or extracted, same result) into a blank Excel sheet. One of the problems that has recently come up is with the ZIP Code field, for example. While the database defines this as a Number, when it is pasted into Excel, it is seen as a text. When the cell is edited (via F2) or if you add 0 to it, the cell converts back to Number which is should be. Is there a way to get these to stay as a number when extracted from Access into Excel?
Copied to Excel w/Pseudo-Number
- Thread starter Badswell
- Start date
