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
 

Excel Facts

Excel motto
Not everything I do at work revolves around Excel. Only the fun parts.

JoeMo

MrExcel MVP
Joined
May 26, 2009
Messages
17,932
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!
 
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

Forum statistics

Threads
1,168,032
Messages
5,856,939
Members
431,841
Latest member
jaybeem

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top