Dear Friends,
When someone prepare some reports and wanna pun headings like “For the month of December, 2009”
“Report for the month of January, 2010”
Than the question comes in mind that "Is there any way so the month will be automatically updated?"
Answer is yes there is a simple way for this first put the formula of today in the cell that is "=Today()" and than do the small work as described under
GO to format cells--->Custom-->"For the month of" mmmm-yy--->Click Ok
and you will get the desired result.
Regards
Hemant
Microsoft Excel the best software, in my opinion, that is created by human being. In this blog, you will find related stuff with this software. I am not here to solve any problem with Excel. I am here to helping you all and my self to understand the software and gain more knowledge about it.
Subscribe to:
Post Comments (Atom)
Hi Friends, After a long break, I again started to work on this blog with new time-saving techniques and tricks for making the day to day...
-
If you need to analyze data from a Web site, you might be in for a bunch of tedious retyping. Under the right circumstances, however, Excel ...
-
Excel provides several underline formats to give your spreadsheets a professional look and to make them easier to read at a glance. For exam...
-
I was working on my data sheet and countered with one problem I required filters in two row ranges on being specific I want the first fil...
No comments:
Post a Comment