Hi All

I have a report that shows date in this format " yyyymm"

Is there a way of converting it through the formatting feature into "mm" ?

I know about formulae =DATE(LEFT(A4,4),MID(A4,5,2), RIGHT(A4,2)) but I rather avoid adding another column..

Thank you