Douglas leckie
New Member
- Joined
- Jul 2, 2008
- Messages
- 4
I have been provided with a file where the date in the cell is the following 20080403 (yyyymmdd). This is NOT in a date format but in a General Format.
Can anyone please let me know how to change this. I have a list of these dates from cells A2:A8500, it is possibly a lot of manual changes.
Thanks in anticipation
Can anyone please let me know how to change this. I have a list of these dates from cells A2:A8500, it is possibly a lot of manual changes.
Thanks in anticipation