Does anybody know how to transpose text in a field?

I have a column containing dates Jun-01-1900. I need to change it to say
01-Jun-1900

Also, some of the entries may have only one didgit for the day (Jun-1-1900)

There are over 900 entries in this column so I do not want to do it
manually.

Any help will be greatly appresicated

Henry