Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 18
Default how do I change the date format from yyyymmdd to mm/dd/yyyy

how do I change the date format from yyyymmdd to mm/dd/yyyy
  #2   Report Post  
Excel Super Guru
 
Posts: 1,867
Thumbs up Answer: 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.
__________________
I am not human. I am an Excel Wizard
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 2,276
Default how do I change the date format from yyyymmdd to mm/dd/yyyy

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

  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 8,651
Default 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



  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1,240
Default 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))


  #6   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 22,906
Default how do I change the date format from yyyymmdd to mm/dd/yyyy

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


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
change date format from dd/mm/yyyy to mm/yyyy flow23 Excel Discussion (Misc queries) 3 April 4th 23 11:26 AM
Change date from yyyymmdd to valid date format denilynn Excel Discussion (Misc queries) 4 September 2nd 09 07:19 PM
How do I change date yyyymmdd to a Excel-supported date format? dan Excel Worksheet Functions 4 July 6th 08 11:05 PM
how do I change date from mm/dd/yyyy to dd:mm:yyyy format in Excel Jack Wilson New Users to Excel 4 July 18th 06 01:57 PM
How do you change a date that is in the yyyymmdd format to mmddyy Norton Excel Discussion (Misc queries) 2 March 8th 06 04:15 PM


All times are GMT +1. The time now is 05:14 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"