When I opened as a text file no wizard started. It just put all the text
into one cell.

Anyways, I ended up changing the data from "6-1" to "6 to 1"

I wish there was a way to turn off the auto formatting within excel. I
gets very annoying at times.


--
izy
------------------------------------------------------------------------
izy's Profile: http://www.excelforum.com/member.php...o&userid=34942
View this thread: http://www.excelforum.com/showthread...hreadid=546747