>I have a custom format such as:
>
>[$-fr-CA]mmmm yyyy
>
>I need the first letter of the month to be uppercased?
>
>=REPLACE(LOWER(C2),1,1,UPPER(LEFT(C2,1)))
>
>You'll have to run this
Thanks, but I have this in that cell:
=EDATE(A1,A48)
I am trying to find how to incorporate the REPLACE fonction in that one.