Date To Text - Maintaining Format

[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 Phillips]

=TEXT(A1,"dd/mm/yyyy")

 

[Derek Timothy]

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