Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Changing Dates in Excel
I have an invoice that I have created and it shows payments broken down by
week. DESCRIPTION DATE 11 SCREENS 10/5/2007 11 SCREENS 10/12/2007 11 SCREENS 10/19/2007 11 SCREENS 10/26/2007 I would like to have the dates automatically generate and reflect to correct dates by month. Is this possible? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Changing Dates in Excel
format the cells how you want them
hightlight the row. goto format then custom in the top box type MMM DD YY wll give you the results by mth first "mattie" wrote: I have an invoice that I have created and it shows payments broken down by week. DESCRIPTION DATE 11 SCREENS 10/5/2007 11 SCREENS 10/12/2007 11 SCREENS 10/19/2007 11 SCREENS 10/26/2007 I would like to have the dates automatically generate and reflect to correct dates by month. Is this possible? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Dates Keep changing in Excel Charts | Excel Discussion (Misc queries) | |||
Prevent excel changing numbers data to dates. | Excel Discussion (Misc queries) | |||
Stop Excel from changing numbers to dates in CSV file | Excel Discussion (Misc queries) | |||
How do I keep excel 2002 from changing fractions to dates? | Excel Discussion (Misc queries) | |||
Changing Dates in Excel | Excel Worksheet Functions |