Hi,

I have a problem about date format transfering . For
example, one column containing the date data in the
format like "20040415" , now I want to change it to the
format like "04/15/2004". As always,thanks so much in
advance.

Meme

Is that a date or a number? If it is a date, just change the format
(FormatCells).

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"Meme" wrote in message
...
Hi,

I have a problem about date format transfering . For
example, one column containing the date data in the
format like "20040415" , now I want to change it to the
format like "04/15/2004". As always,thanks so much in
advance.

Meme

It is a text format like '20040415, not a number.
Thanks

-----Original Message-----
Is that a date or a number? If it is a date, just change
the format
(FormatCells).

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"Meme" wrote in
message
...
Hi,

I have a problem about date format transfering . For
example, one column containing the date data in the
format like "20040415" , now I want to change it to the
format like "04/15/2004". As always,thanks so much in
advance.

Meme



.

=DATE(LEFT(A1,4),MID(A1,5,2),RIGHT(A1,2))

Meme wrote:
Hi,

I have a problem about date format transfering . For
example, one column containing the date data in the
format like "20040415" , now I want to change it to the
format like "04/15/2004". As always,thanks so much in
advance.

Meme

20040415 stored in a cell is either a string, or the number 10,020,415


Dim dDate as Date
sStr = activeCell.Text
dDate = DateValue(right(sStr,2) &"/" & Mid(sStr,5,2) & "/" & Left(sStr,4))

--
Regards,
Tom Ogilvy


"Meme" wrote in message
...
Hi,

I have a problem about date format transfering . For
example, one column containing the date data in the
format like "20040415" , now I want to change it to the
format like "04/15/2004". As always,thanks so much in
advance.

Meme