Format month

In my report i need to change format to E_Month field;
from this data '200502' change format to this '02/2005'.
How should i change that?
Thank you.How about
=Right(E_Month,2) & "/" & Left(E_Month,4)
?
Michael C
"GGill" wrote:
> In my report i need to change format to E_Month field;
> from this data '200502' change format to this '02/2005'.
>
> How should i change that?
> Thank you.|||Thanks.
It works.
"Michael C" wrote:
> How about
> =Right(E_Month,2) & "/" & Left(E_Month,4)
> ?
> Michael C
>
> "GGill" wrote:
> > In my report i need to change format to E_Month field;
> > from this data '200502' change format to this '02/2005'.
> >
> >
> > How should i change that?
> >
> > Thank you.