software

I have a column of dates formatted as mm/dd/yy. I want to add another column
that returns the month in two characters (i.e. 7/31/95 would return 07). I
am using the month function but it only returns one character (i.e.7).

Does anyone have any suggestions? thanks

In the cell you have the MONTH() function:

lt;Formatgt;lt;Cellsgt;
Click over to the quot;Numberquot; tab
Click on quot;Customquot;
Enter quot;00quot; (without the quotes)

--
Regards,
Davequot;Moquot; wrote:

gt; I have a column of dates formatted as mm/dd/yy. I want to add another column
gt; that returns the month in two characters (i.e. 7/31/95 would return 07). I
gt; am using the month function but it only returns one character (i.e.7).
gt;
gt; Does anyone have any suggestions? thanks

See if one of these will work for you:

For a date in A1
B1: =TEXT(MONTH(A1),quot;00quot;)

OR

B1: =MONTH(A1)
Formatgt;Cellsgt;Number tab
Category: Custom
Type: 00
Click the [OK] buttonDoes that help?

***********
Regards,
Ron

XL2002, WinXP-Proquot;Moquot; wrote:

gt; I have a column of dates formatted as mm/dd/yy. I want to add another column
gt; that returns the month in two characters (i.e. 7/31/95 would return 07). I
gt; am using the month function but it only returns one character (i.e.7).
gt;
gt; Does anyone have any suggestions? thanks

Thanks, it worked perfectly.

quot;David Billigmeierquot; wrote:

gt; In the cell you have the MONTH() function:
gt;
gt; lt;Formatgt;lt;Cellsgt;
gt; Click over to the quot;Numberquot; tab
gt; Click on quot;Customquot;
gt; Enter quot;00quot; (without the quotes)
gt;
gt; --
gt; Regards,
gt; Dave
gt;
gt;
gt; quot;Moquot; wrote:
gt;
gt; gt; I have a column of dates formatted as mm/dd/yy. I want to add another column
gt; gt; that returns the month in two characters (i.e. 7/31/95 would return 07). I
gt; gt; am using the month function but it only returns one character (i.e.7).
gt; gt;
gt; gt; Does anyone have any suggestions? thanks