| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
Change Text Data to Date
Hi All:
I have a problem to change text data to date. I have a variable named graduate date indicated as Fall 1998 Spring 2000 Summer 2000 Now I need to change Fall to 01/09, Spring to 01/02, and Summer to 01/06 or without back slash (/). Could anyone tell me how I can accomplish these changes? Thanks a lot in advance. Charles |
|
#2
|
|||
|
|||
|
Is your spreadsheet too big to do a find/replace?
Carole O "Charles" wrote: Hi All: I have a problem to change text data to date. I have a variable named graduate date indicated as Fall 1998 Spring 2000 Summer 2000 Now I need to change Fall to 01/09, Spring to 01/02, and Summer to 01/06 or without back slash (/). Could anyone tell me how I can accomplish these changes? Thanks a lot in advance. Charles |
|
#3
|
|||
|
|||
|
Hi Carole:
I think you are right. I just forgot this. Thanks a lot. Charles "Carole O" wrote: Is your spreadsheet too big to do a find/replace? Carole O "Charles" wrote: Hi All: I have a problem to change text data to date. I have a variable named graduate date indicated as Fall 1998 Spring 2000 Summer 2000 Now I need to change Fall to 01/09, Spring to 01/02, and Summer to 01/06 or without back slash (/). Could anyone tell me how I can accomplish these changes? Thanks a lot in advance. Charles |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Display Date that does not change everyday. | Excel Discussion (Misc queries) | |||
| Change cell color dependin on date ... | Excel Worksheet Functions | |||
| VBA to change size of data labels? | Charts and Charting in Excel | |||
| Excel enters date as a text format | Excel Discussion (Misc queries) | |||
| Convert data of cells to any type: Number, Date&Time, Text | Excel Discussion (Misc queries) | |||
Hybrid Mode
