Date Formatting in a Macro

Giganews Newsgroups
Subject: Date Formatting in a Macro
Posted by:  gregersanders…
Date: 18 May 2006

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


Greg A