| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
date & time format and autofill
I have a list in text format as follows:
27/03/2006 00:00 28/03/2006 00:00 29/03/2006 00:00 30/03/2006 00:00 & I would like to use autofill to creat a list of each day of the year. However, when I try to do this, it just adds on seconds rather than continuing with the days. How can I get the list to carry on in the same format, without changing the cell format? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Autofill Date/Time | Excel Worksheet Functions | |||
| Autofill: Need to autofill one week block, (5) weekday only into cells. | Excel Discussion (Misc queries) | |||
| Autofill macro | Excel Discussion (Misc queries) | |||
Threaded Mode
