View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Mo
 
Posts: n/a
Default Formatting month values

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