Could you please help me how to create in format cells a date format using only upper case letters, example: August 05, 2012 for AUGUST 05, 2012.

I am trying to copy or move some work sheets from one file to another but when I move them they don't keep the theme colors and format. Could you please tell me how can I move them keepin all theme colors and formats.