Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Date Formatting in a Macro
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel Macro save as date of last friday | Excel Discussion (Misc queries) | |||
Macro not formatting correctly | Excel Discussion (Misc queries) | |||
formatting date-time values in macro | Excel Worksheet Functions | |||
NETWORKDAYS - Multiple Date Selection | Excel Discussion (Misc queries) | |||
Conditional Formatting Based on Date | Excel Discussion (Misc queries) |