Try this

Select the column with the suspicious dates.
Data - Text To Columns - Select Delimited - Select Next -Select Next
Choose DATE and select your date format

--
HTH,
Barb Reinhardt

If this post was helpful to you, please click YES below.



Eva Marie" wrote:

Hi Max,

I'm not sure if I will be able to do so as I work for a company that has
secret military clearance and the data in the spreadsheet is classified. I
will see what I can do to upload an example and post the link.

Thanks!
Eva Marie

"Max" wrote:

Tough to check. Could be a data consistency issue, eg what should have
apparently matched (and returned a valid result) doesn't, because say, some
dates are not real dates (real dates are numbers, and it won't match with
text numbers), etc

Can you upload a sample file using a free filehost,
then post a link to it here?

For example, you could use this free filehost to upload:
http://www.freefilehosting.net/

Copy the "direct link" which is generated after you upload,
then paste it here

(Desensitize your sample as appropriate)
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:18,300 Files:361 Subscribers:58
xdemechanik
---
"Eva Marie" wrote:
Hi Max,

Thank you for your help too! I copied this entire formula into the cell and
then dragged it down into the below cells to copy the formula into them.
Unfortunately, when there is a value to be displayed, such as "10/13/08", it
makes the cell blank, rather than displaying 10/13/08. It definitely works
with the #N/A cells, where no value was returned.

I'd appreciate any help on getting values to display, while still hiding the
#N/A.

Thanks!
Eva Marie