How do you use the find and replace tool to find dates and times in Excel 2013?

BobBridges · #2 04-13-2020, 07:59 PM

I'm always uncertain when I have to look for numbers that may be formatted in special ways. But Excel is pretty smart about finding "321" among various currency figures in my checkbook worksheet; it hits on 321, 321.25, 2321.55 and so on. So it can probably do it for times as well.

Can you post the worksheet you're searching in? One of us can try it for ourselves and see whether anything special is required.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Find & Replace tool no longer comes up	Literalman	Word	3	07-13-2015 03:07 PM
Find what box in Find and replace limits the length of a search term	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
Bad view when using Find and Find & Replace - Word places found string on top line	paulkaye	Word	4	12-06-2011 11:05 PM
Find and Replace: Dates	Attirb	Word	2	04-13-2011 09:56 AM