The Excel Trainer
  • Live Training
  • Free Tutorials
  • Newsletter
  • Partners
  • Contact Mike
Select Page

Converting Date Format Using Text To Columns

May 25, 2013

A customer sent through a spreadsheet with what appeared to be dates displayed in column A in the format YYYY-MM-DD. The spreadsheet was the result of a data export from a bespoke system and the “dates” were actually text entries. The customer wanted the...

Recent Tutorials

  • Do You Want Early Access to Excel Updates?
  • Why You Should NOT Buy Excel 2019
  • Excel – Import a List of Tasks into Outlook
  • Excel – NEW in March 2018: Geography and Stock Data Types
  • Excel – Create a Pivot Table Using Excel Online
  • INDEX & MATCH v VLOOKUP / HLOOKUP
  • Excel Slicers – 2 Pivot Tables Based on Different Data Sources
  • Excel 2010 – Create a Combo Chart
  • Power Pivot and Power Query
  • Excel – What is a Dashboard?

© 2012-2021 - theexceltrainer.co.uk    Privacy Policy