View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Quco Quco is offline
external usenet poster
 
Posts: 33
Default Excel changes the value of a cell to a DATE!!!!

We have a text document (.txt file) a client sent us with a listing of
coordinates X, Y, Z. We also have a last column that identifies the type of
point to analyze. The text document is tab-delimited. I need to create a
Comma Delimited File (.csv) of the text document, so I thought I can use
Excel 2007 to do this:

1) Open Excel 2007
2) File Open
3) Select the text document
4) Text Wizard Import opens and I select Delimited Next Delimeters: Tab
Next Column Data Format: General Finish.

5) So far, Excel has done a wonderful job of separating my data on each
cell. I now select Save As and choose the CSV format.

PROBLEM IS:

The ID column for each coordinate has the following format: ##-#, and Excel
changes that content to a DATE! For example: "02-1" becomes "1-Feb". How can
I "teach" Excel to avoid doing that?????