Cutting and Pasting numbers in a column

Hello

I am trying to use VBA to cut and paste a date, so that the day i.e 12/01/2011 becomes the month i.e 01/12/2011.

I Have the following so far but am not an expert on the syntax so got a bit stuck.


Any ideas

Please Login or Register  to view this content.

Steffen Thomsen

Hello

Thank you for your help

I am looking to do this for many numbers in a column for example

Please see attachment.

Hi,

You can use this.

This goes threw the range and converts the dates to string and places then in another column

Please Login or Register  to view this content.

Steffen Thomsen