dates from inhouse system download as text.Convert back to date?

  • Thread starter Thread starter ShazBat
  • Start date Start date
S

ShazBat

When I download a report from our inhouse system to excel the dates appear as
text. Can I convert them back to dates - and if so - how?
 
--Select the range of dates which needs to be corrected.
--From menu Data>Text to Columns will populate the 'Convert Text to Columns
Wizard' Hit Next>Next will take you to Step 3 of 3 of the Wizard.
--From Column Data format select Date and select the date format in which
your data is (MDY or DMY or what ever it is) .
--Hit Finish. MSExcel will now convert the dates to the default date format
of your computer.

If this post helps click Yes
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Which is the best MBOX Converter Tool different formats conversion? 4
Special string convertion to date and time 4
Display date in spanish 3
Date Conversion 5
PowerPoint Presentation opens in work mode with Vista 1
Famous days calendar import 1
How do i convert dates to text but keep the date format 1
Date format problems after csv import 2

Back
Top