Converting Date to Text String

[John Calder]

Hi

I would like to convert a date (eg; 05/01/2005) to text so that in one
column it shows 05 as text, in the next column Jan as text and in a 3rd
column 2005 as text.

Can anyone help me with this

Thanks

John Calder

[Ron Rosenfeld]

On Thu, 7 Apr 2005 17:07:02 -0700, "John Calder" <John
[email protected]> wrote:

>Hi
>
>I would like to convert a date (eg; 05/01/2005) to text so that in one
>column it shows 05 as text, in the next column Jan as text and in a 3rd
>column 2005 as text.
>
>Can anyone help me with this
>
>Thanks
>
>John Calder

If you date is in A1:

B1: =TEXT(A1,"dd")
C1: =TEXT(A1,"mmm")
D1: =TEXT(A1,"yyyy")
--ron

[John Calder]

Thanks Ron...works great !

"Ron Rosenfeld" wrote:

> On Thu, 7 Apr 2005 17:07:02 -0700, "John Calder" <John
> [email protected]> wrote:
>
> >Hi
> >
> >I would like to convert a date (eg; 05/01/2005) to text so that in one
> >column it shows 05 as text, in the next column Jan as text and in a 3rd
> >column 2005 as text.
> >
> >Can anyone help me with this
> >
> >Thanks
> >
> >John Calder
>
> If you date is in A1:
>
> B1: =TEXT(A1,"dd")
> C1: =TEXT(A1,"mmm")
> D1: =TEXT(A1,"yyyy")
> --ron
>

[Ron Rosenfeld]

On Thu, 7 Apr 2005 18:57:02 -0700, "John Calder" <John
[email protected]> wrote:

>Thanks Ron...works great !

You're welcome. Glad to help.
--ron