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

[tommasopalazzot]

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

[Tom Ogilvy]

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@excelforum-nospam.com> wrote in
message news:tommasopalazzot.1wa8ec_1128269115.728@excelforum-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
>