Difference between revisions of "Change Date Formats in Microsoft Excel"
m (importing article from wikihow) |
m (Text replacement - "== Video ==" to "") |
||
| (4 intermediate revisions by the same user not shown) | |||
| Line 1: | Line 1: | ||
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. You can choose to change the date format for a specific set of data within an Excel sheet, or you can change the standard date format for your entire computer in order to apply that format to all future Excel sheets. | 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. You can choose to change the date format for a specific set of data within an Excel sheet, or you can change the standard date format for your entire computer in order to apply that format to all future Excel sheets. | ||
| − | [[Category:Microsoft Excel]] | + | [[Category: Microsoft Excel]] |
== Steps == | == Steps == | ||
===Changing the Standard Date Format=== | ===Changing the Standard Date Format=== | ||
| Line 38: | Line 38: | ||
#Select the date format you'd like. Highlight that choice, and click "OK" to save the format. Then, save the file to ensure that your formatting is preserved | #Select the date format you'd like. Highlight that choice, and click "OK" to save the format. Then, save the file to ensure that your formatting is preserved | ||
| − | + | ||
| − | + | ||
== Tips == | == Tips == | ||
