Undo auto data formatting

[christy_nf]

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!!!

 

[Legacy 98055]

Hi Christy,
Before pasting your data,
format the cells as text.
Tom

 

[klb]

Before you paste the information, set the format for all of the cells as text. Then, use paste special values instead of paste.

Good luck,

 

[christy_nf]

Thanks, TsTom and klb, that worked like a charm!