Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Disable formatting on csv open?
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...o&userid=34594 View this thread: http://www.excelforum.com/showthread...hreadid=543670 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Disable formatting on csv open?
"Heather1270"
wrote in message ... 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? The easiest way is to rename the file to .txt instead of .csv, then the text import wizard allows you to select the format for each column. -- David Biddulph |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How can I disable macros after the initial open? | Excel Discussion (Misc queries) | |||
XLSTART doesn't open PMW | Excel Worksheet Functions | |||
When I open excel document it always ask if I want to open it in . | Excel Discussion (Misc queries) | |||
Conditional formatting not available in Excel | Excel Discussion (Misc queries) | |||
Cannot open a file that Excel says is open | Excel Discussion (Misc queries) |