I have a large data base where the date column is posted as 19950312 which means March 3, 1995. I cannot figure out how to format the cells for excel to read that as that date. any suggestions? I have tried to use the custom format function to no avail.
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
date format
- Thread starter jtjes
- Start date
Corticus
Well-known Member
- Joined
- Apr 30, 2002
- Messages
- 1,579
I couldn't get a custom format to do it, but this formula works, and Excel will recognize the resulat as a date.
HTH
Corticus
| Book1 | ||||||
|---|---|---|---|---|---|---|
| A | B | C | D | |||
| 1 | DB Date: | Standard Date: | ||||
| 2 | 19950312 | 03/12/1995 | ||||
| 3 | 19950313 | 03/13/1995 | ||||
| 4 | 3/14/95 | |||||
| 5 | 3/15/95 | |||||
... | ||||||
HTH
Corticus
Upvote
0
