Cheers, for some reason a restart fixed the problem :S weird, but I
appreciate the list of different Formats you presented. I shall give them a
whirl.

Thanks again!

"Mark Ivey" wrote:

Here are some formatting features you might find useful....

Mark Ivey

Note: you can replace the "Range("A1")" with the cell reference you were
using if you prefer



MsgBox Range("A1").Value

MsgBox Format(Range("A1").Value, "MM/DD/YY")
MsgBox Format(Range("A1").Value, "DD/MM/YY")
MsgBox Format(Range("A1").Value, "DDD MM/DD/YYYY")
MsgBox Format(Range("A1").Value, "DDD MMM DD YYYY")
MsgBox Format(Range("A1").Value, "DDD MMMM DD YYYY")