You might have used Microsoft Excel sometime if you ever created excel sheets etc. The MS Excel is a powerful tool and a part of Microsoft Office Suite. I use MS Excel for creating sheets, reports and maintain financial data also.
I usually use one or two columns to enter dates associated with events. One problem I used to face when I started using MS Excel was the display of Dates in Excel sheets. The dates appeared weird, sometimes different rows displayed dates in different formatting, it makes the sheets hard to understand. In this article, I will tell you a simple way to display the dates in your excel sheets correctly and neatly.
The way dates appear In MS Excel largely depends on the format you enter them in the cell, for example, if I enter date as “15 April 2010”, it will show like “15-APR-10” in the destination cell. See the example snapshot below:
To change the way dates look in MS Excel, right click on any of the date entry and click the option called “Format Cells…”
This will open a Format Cells window as seen below. In my case, the format selected was a custom format which shows Date-Month-Year format of date because I entered it that way. To change the way or format to show dates in MS Excel, just click the Category “Date” on the left hand pane on this window and you can see the formats of the dates supported with examples and then select the one which you want to keep.
When I click date, the formats available include :
- Day, Month Date, Year
and lot more. You just need to try and few to figure out what suits you the best. Once you find out which format of date you need in your excel sheet, click OK.
Below is the changed format I applied to the cell c3 with entry April 14 2010 to show Day,Month Day , Year format. To apply this format to remaining cells in this column, I can either select all of them together and use format cells, which is a quick way. Other way is just to replicate the above style for all the entries.
To replicate the style or format of the cell c3 to all the remaining cells, just click to select the cell C3 and click on “Format Painter” option which looks like a paint brush. This copies the style of this cell and allows you to apply this style to other cells.
Here it goes, the same format applied to all the cells below it by using the format painter tool.
Hope you will find this tip easy to follow. In case you have any specific queries about MS Office, you can ask your query at answers.troublefixers.com or mail us as admin[at]troublefixers[dot]com. You can check out more tips on Microsoft Excel and Microsoft Word