BradleyS
Active Member
- Joined
- Oct 28, 2006
- Messages
- 361
- Office Version
- 365
- 2019
- 2016
- 2010
- Platform
- Windows
I have lots of dates that are not entered correctly in a single column of data and are messing up my formulas, instead of having to trawl through hundreds of these dates, is it possible to automatically convert them to 01/01 and show the actual year.
For example:
1951 should be 01/01/1951
1922 should be 01/01/1922
I tried conditional formatting but couldn't get it to work.
Any suggestions would be most appriciated.
Thank you.
For example:
1951 should be 01/01/1951
1922 should be 01/01/1922
I tried conditional formatting but couldn't get it to work.
Any suggestions would be most appriciated.
Thank you.