Apparently you have to add an apostrophe to the beginning of each cell
in the column that you want to link as text. Set up a macro to do that
and it works just fine.
Wasted a couple of hours figuring it out.
Access and Excel seems to be very stubborn when looking at the first 10
or so rows to determine type. I hoped reversing my sort to put the
alphanumeric rows first would do the trick, but can you say NOT! The
alphanumeric entries did fine and the numerics were nailed with a #NUM!
The apostrophe trick worked just fine (except it means that each cell
in the selected column now has an apostrophe which is not real data).
Thanks.
SPONSORED LINKS
| Microsoft access database | Database development software | Database management software |
| Database software | Inventory database software | Membership database software |
YAHOO! GROUPS LINKS
- Visit your group "ms_access" on the web.
- To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
- Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
