View Single Post
 
Old 04-14-2020, 04:30 AM
Jules90 Jules90 is offline Windows 8 Office 2013
Novice
 
Join Date: Apr 2019
Posts: 24
Jules90 is on a distinguished road
Default

Hi Bob,


Thanks for replying to my post - much appreciated.


The problem I was having with finding both dates, and times in particular, was a combination of two schoolboy or in my case schoolgirl errors!


I spent a good while this morning going over the custom number formats and option choices, which helped me noticed what I had been doing wrong when using the Find box. It was a lack of attention to detail.


There were two things: I was putting a stop between the hour and minutes instead of a colon, and I also wasn't making sure I'd chosen the option 'look in Values' before hitting Find Next. The other with regard to dates was when entering into the Find What box I wasn't careful enough of entering exactly how the date was entered in the worksheet e.g. if it was written in the worksheet as 24/03/2019, I had entered 24/3/2019!


Thanks again for your reply.
Cheers
Reply With Quote