Selection.NumberFormat = "dddd, mmmm, dd, yyyy"

make sure the column is wide enough to display the data, or you will get
####. Or, use Autofit

Selection.Columns.AutoFit


" wrote:

I have been trying to create a date macro in which I input the date on
the first sheet and it then continues onto the other sheets, I have
been parcially sucessful but I would like the Date to appear in this
format dddd, mmmm dd, yyyy ( Sunday, January 1, 2006) but all I get is
a bunch of pound signs in the excel sheets.

Does anbody have any idea on how to fix this or have a better way of
getting it to do this
and then for some other reason I can't get it to auto run when I open
the workbook.

Hope some one can help

Thanks

Greg A