Help! Dates

[Revs2Nine]

My wife is working on a spreadsheet from work that has the dates formatted wrong and I can not figure out how to fix it. They are dumping the information through their database and the date is pulling 2010/10/10 but formatting the cells wont work. Can anybody help. Thanks

 

[JoeMo]

Maybe try trimming and converting to a value. Say in cell A1 you have 2010/10/10 then in cell B1 enter:

=VALUE(TRIM(A1))

Format B1 as date with whatever date format you want. There may also be hidden characters with the imported data, but have a quick try with this.

 

[Revs2Nine]

That worked. Amazing how you think you know a lot in Excel and really know nothing. HAHA Thank you!