Problem with converting dates to text

[Seraph84]

Hi,

I have the following code, trying to convert a column of dates to a specific text format:

Please Login or Register  to view this content.

The problem is the dates remain as numeric dates. I have since found this is to do with the .Values property.

Any suggestions for a quick way to get around this? Copy and paste special?

Thanks

[haripopuri]

To change the format.

Please Login or Register  to view this content.

[alansidman]

TEXT is a worksheet function and not a VBA function.

Try using the Format function

=FORMAT(C2,"dd mm yy")