gingerbreadgrl
New Member
- Joined
- Aug 19, 2019
- Messages
- 48
Hi,
I am using a software program to export my data into excel, then using a macro to organize the data. Unfortunately, the software program only has the option to have both date AND time exported so the cells containing that data look like the following:
8/29/2019 4:00 PM
This occurs in just one column in the entire spreadsheet. Is there a way to format the cells in that column so that the time can be deleted and the date would be the only data left in the cell?
I anticipate having maybe 10 rows of data in that column so if it would be easier to just format the cell instead I could just copy and paste the code and change it for each cell too.
Thanks,
Gingerbreadgrl
I am using a software program to export my data into excel, then using a macro to organize the data. Unfortunately, the software program only has the option to have both date AND time exported so the cells containing that data look like the following:
8/29/2019 4:00 PM
This occurs in just one column in the entire spreadsheet. Is there a way to format the cells in that column so that the time can be deleted and the date would be the only data left in the cell?
I anticipate having maybe 10 rows of data in that column so if it would be easier to just format the cell instead I could just copy and paste the code and change it for each cell too.
Thanks,
Gingerbreadgrl