Date format change from yyyymmdd to mm/dd/yyyy

G

Guest

Need to change the date format from yyyymmdd to mm/dd/yy. Tried setting up a custom format with no results
 
P

Peo Sjoblom

Select the column, do data>text to columns, click next twice and under
column data format select date, from scrolldown select YMD and click finish.
There is no way excel could know that a number like 20031203 is a date as
opposed to a number just by formatting, since excel dates are days since Jan
0 1900 and a date like 12/03/03 is equal to 37958, then the number 20031203
will just return ####### if formatted as a date


--

Regards,

Peo Sjoblom


Peter said:
Need to change the date format from yyyymmdd to mm/dd/yy. Tried setting
Click to expand...
up a custom format with no results
 

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

Excel date format YYYYMMDD 1
Date Seperator 2
How do I change my date from this format 20070507 to 05/07/07? 1
How do I change the date format? 3
INDEX MATCH but need to change return Values 2
Excel 2002: How to make the date format uniform ? 1
Convert YYYY, MM, and DD as a single number string 13
how do I change the date format from yyyymmdd to mm/dd/yyyy 4

Top