Date formatting for collums

Hi All,

am trying to write a macro for a collums to use the date formating dd-mmm-yyyy as i have alot of columns to update!

please help

Try:

Please Login or Register  to view this content.

HTH

Jason

Thank you that works great..one more thing

I got help with another matter same dating issue
i would like to step out of a for loop if there's no information found withing the collumn.
here's the code
For j = 13 To 14
Range(Cells(7, j), Cells(LastRow, j)).TextToColumns _
Destination:=Cells(7, j), DataType:=xlDelimited, _
FieldInfo:=Array(1, 4)
Columns(j).EntireColumn.AutoFit
IF columns(j).value = "" then
exit for
end if

Next j
the for loop is okay it's the if that i need help or how to ignore the column and move to the next without it prompting a warning.

Thanks VB_Noob it works!