Hi all,

I have a variable which contains a date value (say date value is in A1). I want to paste this date value into a cell (say A2) but change the format from "mm/d/yyyy" to say "mm/d/yy". Here is the code i use.........but it doesnot work.

junk1 = Format(alert_due_date_value, "mm/d/yy")
alert_due_date_value is the variable which contains the date........i try to convert its format to mm/d/yy and store result in variable junk1 but the displayed value in junk1 is the same as that for alert_due_date_value........any ideas what to do?