View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
Tom Hutchins Tom Hutchins is offline
external usenet poster
 
Posts: 1,069
Default Add 0 before month 1 to 9?

If the Year is in column A and the Month is in column B, try in column C:

=A2&", "&IF(B2<10,"0"&B2,B2)

Hope this helps,

Hutch

"Cam" wrote:

Hello,

I am not sure how to use the formula or function that CONCATENATE two fields
based on a IF function.
If the month field is 1 to 9, then add 0 before the month, then concatenate
the year & month.
Example Data:
Year Month Concatenate Result
2007 3 2007, 03
2007 4 2007, 04
2008 12 2008, 12
2008 6 2008, 06
2009 10 2009, 10