HomePro
Board Regular
- Joined
- Aug 3, 2021
- Messages
- 157
- Office Version
- 365
- 2021
- 2019
- 2016
- 2013
- 2011
- 2010
- 2007
- 2003 or older
- Prefer Not To Say
- Platform
- Windows
- MacOS
- Mobile
- Web
I have a column on a sheet with date/ times I want to sort. But to do so I need to pad the day and the month. Or change the date format on the column. But it will not change.
Any idea why?
Any idea why?
Appointment_General_Data.xlsx | |||
---|---|---|---|
A | |||
1 | Added_Date | ||
2 | 7/6/2022 8:55 AM | ||
3 | 7/6/2022 9:02 AM | ||
4 | 7/6/2022 9:03 AM | ||
5 | 7/6/2022 9:09 AM | ||
6 | 7/6/2022 10:26 AM | ||
7 | 7/6/2022 12:18 PM | ||
8 | 7/6/2022 12:26 PM | ||
9 | 7/6/2022 12:43 PM | ||
10 | 7/6/2022 1:33 PM | ||
11 | 7/6/2022 2:26 PM | ||
Sheet2 |