Disable formatting on csv open?

Giganews Newsgroups
Subject: Disable formatting on csv open?
Posted by:  Heather1270 (Heather1270.281vbm_1148034301.2838@excelforum-nospam.com)
Date: Fri, 19 May 2006

Hi!

When opening a csv file in 2003, Excel "formats" the data - it coverts
one field that is text but looks suspiciously like a date to a date
field. Is there a way to disable this or set Excel to open the file
with all fields formatted for text?

Thanks!
Heather

--
Heather1270
------------------------------------------------------------------------
Heather1270's Profile:http://www.excelforum.com/member.php?action=getinfo&userid=34594
View this thread:http://www.excelforum.com/showthread.php?threadid=543670

Replies