Hi,
I have this date and time value (Friday, October 15, 2004 10:35:12) stored
in a cell ("E80"). I need to format it to 10/15/04 and paste it in another
spreadsheet. What is doing right now is changing to today's day.... I just
need the date, ignore the time.

I've tried Format(Date, "mm/dd/yy") and this is the one giving me todays
date...

Help... this formatting date is not making my date ...

--
gaba :)