formating cells in excel with code

does anybody know how to format an entire columb of cells to a desired date format using tools with a windows application.

Who is Participating?
James_WyattConnect With a Mentor Commented:
Once you have created a reference to the active worksheet all you need to do is

myActiveWorksheet.Range("a:a").NumberFormat = "dd.mmm.yyyy"

Range("a:a") selectes the whole of column A.

mackie1908Author Commented:
Hi James

thanks for this it has been bugging me so much. i know it seems like a bit of a sad issue to have such a big deal with but i am very gratefull cheers

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.