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

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

FAQ

Thread Tools

Display Modes

04-12-2020, 03:27 AM

Jules90

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

Windows 8

Office 2013

Novice

Join Date: Apr 2019

Posts: 24

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

« Previous Thread | Next Thread »

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

Other Forums: Access Forums

All times are GMT -7. The time now is 04:13 AM.