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



.