![]() |
|
|
Thread Tools | Display Modes |
#3
|
|||
|
|||
![]()
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 |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
![]() |
Literalman | Word | 3 | 07-13-2015 03:07 PM |
![]() |
Hoxton118 | Word VBA | 7 | 06-10-2014 05:05 AM |
Leader Dots with Find & Replace Tool? | binar | Word | 1 | 01-10-2013 04:26 AM |
![]() |
paulkaye | Word | 4 | 12-06-2011 11:05 PM |
![]() |
Attirb | Word | 2 | 04-13-2011 09:56 AM |