lezawang
Well-known Member
- Joined
- Mar 27, 2016
- Messages
- 1,805
- Office Version
- 2016
- Platform
- Windows
Hi
I tried to pasteSpecial and mutiply by 1, I tried to use datevalue() function but date and time in column B are not changing. Any idea would be very much appreciated. The link to the file is below.
I tried to pasteSpecial and mutiply by 1, I tried to use datevalue() function but date and time in column B are not changing. Any idea would be very much appreciated. The link to the file is below.
dateandtime.xlsx
drive.google.com
dateandtime.xlsx | ||||||||
---|---|---|---|---|---|---|---|---|
A | B | C | D | E | F | |||
1 | ID | Ordered At | Day | |||||
2 | 1656098 | Jul 13 2020 12:15PM | #VALUE! | Mon | TRUE | |||
3 | 1710182 | Oct 9 2020 11:45AM | Fri | TRUE | ||||
4 | 1710256 | Oct 9 2020 12:42PM | Fri | TRUE | ||||
5 | 1656942 | Jul 14 2020 11:39AM | Tue | TRUE | ||||
6 | 1657357 | Jul 14 2020 4:13PM | Tue | TRUE | ||||
7 | 1657321 | Jul 14 2020 3:43PM | Tue | TRUE | ||||
8 | 1656855 | Jul 14 2020 11:01AM | Tue | TRUE | ||||
9 | 1657429 | Jul 14 2020 4:40PM | Tue | TRUE | ||||
10 | 1653857 | Jul 8 2020 3:31PM | Wed | TRUE | ||||
11 | 1653190 | Jul 8 2020 9:57AM | Wed | TRUE | ||||
12 | 1653194 | Jul 8 2020 10:00AM | Wed | TRUE | ||||
13 | 1654194 | Jul 9 2020 9:41AM | Thu | TRUE | ||||
14 | 1654272 | Jul 9 2020 10:45AM | Thu | TRUE | ||||
15 | 1654358 | Jul 9 2020 11:38AM | Thu | TRUE | ||||
16 | 1657024 | Jul 14 2020 12:23PM | Tue | TRUE | ||||
17 | 1653895 | Jul 8 2020 3:45PM | Wed | TRUE | ||||
18 | 1654520 | Jul 9 2020 12:56PM | Thu | TRUE | ||||
19 | 1654523 | Jul 9 2020 12:58PM | Thu | TRUE | ||||
date andtime |
Cell Formulas | ||
---|---|---|
Range | Formula | |
C2 | C2 | =DATEVALUE(B2) |
F2:F19 | F2 | =ISTEXT(B2) |