Date To Text - Maintaining Format

  • Thread starter Thread starter Derek Timothy
  • Start date Start date
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
 
Bob,

Thats great, thanks a lot. I had tried that but it didn't seem to work. I've
just realised that the cell has to be General before the function is applied
then it can be converted to text.

Many thanks.

Derek
 
Back
Top