thepartydj
Active Member
- Joined
- Sep 23, 2004
- Messages
- 261
- Office Version
- 365
- Platform
- Windows
I would like a macro that will go down one column deleting everything in each cell but the first 9 characters.
for example it will take a text cell with
10/3/2006 15:30:54
to
10/03/2006
I need this because I already have the data and I didn't format the column as date. Thanks
for example it will take a text cell with
10/3/2006 15:30:54
to
10/03/2006
I need this because I already have the data and I didn't format the column as date. Thanks