Undo auto data formatting

christy_nf · Apr 26th, 2002, 06:18 AM

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

Tom Schreiner · Apr 26th, 2002, 06:27 AM

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

klb · Apr 26th, 2002, 06:28 AM

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 · Apr 26th, 2002, 06:34 AM

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

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Apr 26th, 2002, 06:18 AM	#1
christy_nf New Member Join Date: Apr 2002 Location: St. John's, Canada Posts: 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!!!

Apr 26th, 2002, 06:27 AM	#2
Tom Schreiner Board Regular Join Date: Mar 2002 Location: Cincinnati, Ohio, USA Posts: 6,824	Hi Christy, Before pasting your data, format the cells as text. Tom

Apr 26th, 2002, 06:28 AM	#3
klb Board Regular Join Date: Apr 2002 Location: Minnesota Posts: 821	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,

Apr 26th, 2002, 06:34 AM	#4
christy_nf New Member Join Date: Apr 2002 Location: St. John's, Canada Posts: 14	Thanks, TsTom and klb, that worked like a charm!