Dear excel guru
i found very interesting thing while googleing ,about text format . i
want to share with you,
When you nest the TEXT(), MONTH(), and NOW() functions as in the
following example
=TEXT(MONTH(NOW()),"mmm")
Microsoft Excel will always return the result "Jan".
CAUSE
When you format a number using a date format (such as "mmm"), Excel
interprets t...When you format a number using a date format (such as
"mmm"), Excel interprets the number as the serial representation of
the date. The number returned by the MONTH() function is always
between 1 and 12, representing the months of the year.
In the following example, the current date is assumed to be February 1, 1995.
On a spreadsheet, type the following formula into a cell:
=TEXT(MONTH(NOW()),"mmm")
If the current date is February 1, 1995, the function MONTH(NOW())
correctly returns the value of 2. This is equivalent to MONTH(34731)
because 2/1/95 is the 34731st day after 1/1/1900.
TEXT(MONTH(NOW()),"mmm") evaluates to the same value as TEXT(2,"mmm"),
because 2 is the serial representation of 1/2/1900. Therefore, it
returns "Jan".
To enter the formula directly on a worksheet, type the following
formula into a cell:
=TEXT(NOW(),"mmm")
this will return correct month
--
Have A Nice Time & Enjoy Life
Regards:
CMA Ankur Pandey
(Someone Different)
I'm not the best but i'm not like the rest~~
--
----------------------------------------------------------------------------------
Some important links for excel users:
1. Follow us in TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at
http://www.excelitems.com
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
To post to this group, send email to excel-macros@googlegroups.com
If you find any spam message in the group, please send an email to:
Ayush Jain @ jainayus...@gmail.com
<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!
We reach over 6,500 subscribers worldwide and receive many nice notes about the
learning and support from the group.Let friends and co-workers know they can
subscribe to group at http://groups.google.com/group/excel-macros/subscribe
