when I download from the web a "date"...
 

when I download from the web a date,such as 06/12/2004,in excel it i
not in date format.

I need a date in date format,so I can run a macro.

how can I solve the problem?

ex:
if the downloaded date is in cell c4,if in cell d4 I have th
formula:=c4+1,if I click I get:#value!

many thanks

to

--
tommasopalazzo
-----------------------------------------------------------------------
tommasopalazzot's Profile: http://www.excelforum.com/member.php...fo&userid=2773
View this thread: http://www.excelforum.com/showthread.php?threadid=47242

when I download from the web a "date"...
 

select the column and do Data=Text to Columns. Go through the dialogs.
On the last dialog, define the format of the date (the date order) for the
single column you have selected.

--
Regards,
Tom Ogilvy

"tommasopalazzot"
<tommasopalazzot.1wa8ec_1128269115.728@excelforu m-nospam.com wrote in
message news:tommasopalazzot.1wa8ec_1128269115.728@excelfo rum-nospam.com...

when I download from the web a date,such as 06/12/2004,in excel it is
not in date format.

I need a date in date format,so I can run a macro.

how can I solve the problem?

ex:
if the downloaded date is in cell c4,if in cell d4 I have the
formula:=c4+1,if I click I get:#value!

many thanks

tom


--
tommasopalazzot
------------------------------------------------------------------------
tommasopalazzot's Profile:
http://www.excelforum.com/member.php...o&userid=27730
View this thread: http://www.excelforum.com/showthread...hreadid=472425