Date

K

Kevin

hi

I have a workbook that contains several formatted cells


cell "A1" is formated as dd/mm/yyyy and has the today() formula in it

what i want to do is to copy the value of "A1" and paste it into "A4"

ie. "A1" = 13/01/2005
i only want the text value to be copied and pasted into A4
"A4" = 13/01/2005

When i try this i get the numeric value of 38365 which is excels text
value of the date. I need the above format


thanks in advance

kevin
 
D

Don Guillett

Pre format or use edit>paste special or use a formula
=text(a1,"yourformathere")
or a macro
range("a4")=format(range("a1"),"yfh")
 
Top