D
Derek Timothy
Hello All,
It sounds like a simple thing, but I am having a nightmare trying to find an
easy way to take a formated date field and put it into a Text field in the
same format.
For example the date format shows 01/05/2003 if I paste that into a Text
field then I just get the date serial number. If I use a macro like :
day(a1)&"/"&month(a1)&"/"&year(a1) then I get 1/5/2003
Any ideas on how to get 01/05/2003 in the text field?
Many thanks in advance.
Best Regards,
Derek
It sounds like a simple thing, but I am having a nightmare trying to find an
easy way to take a formated date field and put it into a Text field in the
same format.
For example the date format shows 01/05/2003 if I paste that into a Text
field then I just get the date serial number. If I use a macro like :
day(a1)&"/"&month(a1)&"/"&year(a1) then I get 1/5/2003
Any ideas on how to get 01/05/2003 in the text field?
Many thanks in advance.
Best Regards,
Derek