Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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????? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How can I convert a text cell into date cell in Excel | Excel Discussion (Misc queries) | |||
How do I show the day and date in excel in the same cell | Excel Discussion (Misc queries) | |||
cell format for date/time in same cell excel 2003 | Excel Worksheet Functions | |||
how do i combine a date cell and a time cell in excel? | Excel Discussion (Misc queries) | |||
Excel 97 SR-1 / Set date in a cell-have day track in another cell | Excel Discussion (Misc queries) |