How do I convert one data type to another in Excel 2003 in particular, or 2007 or 2010?

doug12
doug12 used Ask the Experts™
on
I want to do more than format the data in a different way, I want to convert the data type in a column somehow from the full date to something that gives me just the month, like say the text "Jun", or just a single number 6 to indicate the 6th month of the year.
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Top Expert 2011
Commented:
<<or just a single number 6 to indicate the 6th month of the year>>

In Format Cells section under the Number tab, you can choose Custom and then designate m for just the numeral month.

 Date with only the month numeral.
Commented:
If you want the number of the month in a decimal value:
=month(cel where date is)

Author

Commented:
Thank to both of you!

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial