Additionally, if you don't want the month truncated to 3 letters use

mmmm dd, ddd

Mike

"Eric" wrote:

Hello,

I have a spreadsheet containing dates in this format, using today, Friday
May 2nd, 2008 as an example:

05/02 F

I wish to change all of these to this format:

May 2, Fri

How do I do this?!

Thanks!!