| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Text turns into date - how to stop?
I have a file that associates codes that look like dates (OCT26 for example)
with a Saints Day. When I export to excel via .csv, it looks like 26-Oct, and if I then pull the cell over into another worksheet, I get the number date code 40112. The column is defined as TEXT. I need to compare the codes to the table via VLOOKUP, so I can disply the description in the report. Is there anyway to tell Excel not to try to make this code a date? (I did try the ' suggestion, but it doesn't work in this case). Martha |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I stop a toolbar that always turns on when I open Excel? | Setting up and Configuration of Excel | |||
| Date Turns Green 90-Days before the date shown in cell | Excel Worksheet Functions | |||
| Is it possible to get Excel to stop formatting text as a date? | Excel Discussion (Misc queries) | |||
| Text turns into #### | Excel Discussion (Misc queries) | |||
| How to stop text changing to date | Excel Discussion (Misc queries) | |||
Threaded Mode
