lezawang
Well-known Member
- Joined
- Mar 27, 2016
- Messages
- 1,805
- Office Version
- 2016
- Platform
- Windows
Hi
I am trying to search for a date in my excel sheet. So I click on Ctrl + F and typed the date. No matter how I type the date, it wont be able to find it. How to search for a date? should I use the same exact format when I search or any format, DD-MM-YY or MM-DD-YY or what? I tried all, nothing works. Thank you so much.
PS: I just tried this.. I cleared the format of these dates (CLear-->format) then I went to Home-->Number-->Short date. The I copied one date and went to CTRL+F and paste that date and excel found it. So is that the solution? Do I have to change the format? Thank you
I am trying to search for a date in my excel sheet. So I click on Ctrl + F and typed the date. No matter how I type the date, it wont be able to find it. How to search for a date? should I use the same exact format when I search or any format, DD-MM-YY or MM-DD-YY or what? I tried all, nothing works. Thank you so much.
Book1 | ||||
---|---|---|---|---|
A | B | |||
1 | 13-Mar-19 | 03-Apr-19 | ||
2 | 03-Apr-19 | 25-Apr-19 | ||
3 | 23-Apr-19 | 25-Apr-19 | ||
4 | 24-Apr-19 | 25-Apr-19 | ||
5 | 30-Apr-19 | 01-May-19 | ||
6 | 02-May-19 | 06-May-19 | ||
7 | 03-May-19 | 07-May-19 | ||
8 | 06-May-19 | 20-May-19 | ||
Sheet2 |
PS: I just tried this.. I cleared the format of these dates (CLear-->format) then I went to Home-->Number-->Short date. The I copied one date and went to CTRL+F and paste that date and excel found it. So is that the solution? Do I have to change the format? Thank you
Last edited: