how do I change the date format from yyyymmdd to mm/dd/yyyy

Sure, I can help you with that!

To change the date format from yyyymmdd to mm/dd/yyyy in Microsoft Excel, you can follow these steps:

1. Select the cells that contain the dates you want to format.
2. Right-click on the selected cells and choose "Format Cells" from the drop-down menu.
3. In the "Format Cells" dialog box, select the "Number" tab.
4. In the left-hand pane, select "Custom."
5. In the "Type" field, enter "mm/dd/yyyy" (without the quotes).
6. Click "OK" to apply the new date format to the selected cells.

Alternatively, you can also use the "Text to Columns" feature to convert the yyyymmdd format to mm/dd/yyyy format. Here's how:

1. Select the cells that contain the dates you want to convert.
2. Click on the "Data" tab in the ribbon.
3. Click on "Text to Columns" in the "Data Tools" group.
4. In the "Convert Text to Columns Wizard," select "Delimited" and click "Next."
5. In the next screen, select "Fixed width" and click "Next."
6. In the next screen, drag the vertical lines to separate the year, month, and day columns.
7. Click "Next" and then "Finish" to convert the dates to separate columns.
8. Select the columns containing the month, day, and year, and then click on "Format Cells" in the "Number" group on the "Home" tab.
9. In the "Format Cells" dialog box, select "Custom" and enter "mm/dd/yyyy" in the "Type" field.
10. Click "OK" to apply the new date format to the selected cells.

Hi,
highlight the range, right click on the mouse, custom format, type mm/dd/yyyy

"Charlene" wrote:

how do I change the date format from yyyymmdd to mm/dd/yyyy

Format/ Cells/ Number/ ...
--
David Biddulph

"Charlene" wrote in message
...
how do I change the date format from yyyymmdd to mm/dd/yyyy

Charlene wrote:
how do I change the date format from yyyymmdd to mm/dd/yyyy

If your data is actually numbers that look like dates in the format "yyyymmdd",
then you would need to do something like this:

=DATE(LEFT(A1,4),MID(A1,5,2),RIGHT(A1,2))

DataText to ColumnsNextNextColumn Data FormatDateYMD and Finish


Gord Dibben MS Excel MVP

On Wed, 16 Sep 2009 09:09:01 -0700, Charlene
wrote:

how do I change the date format from yyyymmdd to mm/dd/yyyy