2091995 - Change Date Formats in Microsoft Excel - Platform

SAP Knowledge Base Article - Public

2091995 - Change Date Formats in Microsoft Excel - Platform

Symptom

  • Have you inherited a document with the dates in the wrong format? Maybe you were the one who made the mistake, or you simply have decided to go a different route. Whatever the reason, you can quickly and easily change the date format in Microsoft Excel.

Environment

  • BizX Platform

Resolution

Steps

  1.  Open the spreadsheet.

     1aa.jpg

 

  1.  Highlight all the date fields.
  • If there's just one cell, click on it.

    1ab.jpg

  • If they are in a column, left-click your mouse on the letter above the column to select and format the entire column.

    1ac.jpg

  • If they are in a row, left-click your mouse on the number beside the row to select and format with the section (or cell) highlighted to bring up the editing menu.

    1ad.jpg

 

  1.  Select "Format" on the bar at the top of the screen.

     1ae.jpg

 

  1.  Select "Cells..." from the drop menu.

    1af.jpg

 

  1.  Make sure the "Number" tab is highlighted.

    1ag.jpg

 

  1.  Select "Date" in the column at the left of the screen.

    1ah.jpg

 

  1. Select the date format you'd like. Highlight that choice.

    1ai.jpg

 

  1.  Click OK to save the format.

     1aj.jpg

 

  1. Save the file. This will ensure your formatting is saved.

     1ak.jpg

Keywords

KBA , sf platform , LOD-SF-PLT , Foundational Capabilities & Tools , How To

Product

SAP SuccessFactors HCM Core all versions