Converting Date to Text String

J

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
 
R

Ron Rosenfeld

On Thu, 7 Apr 2005 17:07:02 -0700, "John Calder" <John
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
Click to expand...

If you date is in A1:

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

John Calder

Thanks Ron...works great !

Ron Rosenfeld said:
On Thu, 7 Apr 2005 17:07:02 -0700, "John Calder" <John


If you date is in A1:

B1: =TEXT(A1,"dd")
C1: =TEXT(A1,"mmm")
D1: =TEXT(A1,"yyyy")
--ron
Click to expand...
 
Top