christy_nf
New Member
- Joined
- Apr 25, 2002
- Messages
- 14
I've copied address ranges from a table and am trying to copy them into a row in an Excel spreadsheet. For example: 1-31 Main Street, with 1-31 in one cell, Main in another cell, and Street in the next cell. It copies in fine but Excel thinks the 1-31 is a date and puts 31-Jan in the cell. I've tried unchecking all the autoformat options but nothing works. It still puts 31-Jan into my address numbers cell. Please help!!!