View Single Post
 
Old 04-12-2020, 03:27 AM
Jules90 Jules90 is offline Windows 8 Office 2013
Novice
 
Join Date: Apr 2019
Posts: 24
Jules90 is on a distinguished road
Question How do you use the find and replace tool to find dates and times in Excel 2013?

Hi all,
Can anyone help me with using the Find and Replace tool in Excel 2013 to find a time e.g. 5:45 PM or a particular date format?


I've entered the time (5:45PM) into the Find box but nothing is coming up when I click Find Next.


I've also tried Options > Format > Number > Date or Time - but still no luck. Can anyone help me with this? Thanks in advance.


Cheers
Reply With Quote