Help! Dates

Revs2Nine

New Member
Joined
Mar 27, 2011
Messages
2
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
 

Some videos you may like

Excel Facts

Can a formula spear through sheets?
Use =SUM(January:December!E7) to sum E7 on all of the sheets from January through December

JoeMo

MrExcel MVP
Joined
May 26, 2009
Messages
17,198
Office Version
  1. 365
  2. 2010
Platform
  1. Windows
Maybe try trimming and converting to a value. Say in cell A1 you have 2010/10/10 then in cell B1 enter:
Code:
=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

New Member
Joined
Mar 27, 2011
Messages
2
That worked. Amazing how you think you know a lot in Excel and really know nothing. HAHA Thank you!
 

Watch MrExcel Video

Forum statistics

Threads
1,108,791
Messages
5,524,897
Members
409,610
Latest member
db321

This Week's Hot Topics

Top