Date format issue

M

Meme

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
 
B

Bob Phillips

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

--

HTH

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

Tom Ogilvy

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))
 
Top