Eric,

If you go to Format--Cells and choose a custom format, you can use
this to get that result:

dddd, mmmm, d, yyyy

You can then apply that format to the other cells in your spreadsheet
that contain dates.

Hope this helps.
Christine Flott

"Eric" wrote in message ...
Hi there,

Can anyone help me please on how to create a date format
in this sample format, I want to write in macro that
automatically substitute them in my reports.

I want this format: "Tuesday, November, 25, 2003".

Can anybody help me please.

TIA
Eric