![]() |
#7
|
|||
|
|||
![]() Quote:
Not sure how that would work for an autofill that isn't a formula, ie fill A1=1 A2=2 to a30 Quote:
Typing 1/1 or 31-Jan or 1/1/14 and then 2/1 (as per original) will autofill when the handle is dragged or you use CTRL-downarrow. I've only ever seen the problem with filling dates in any format when you've pasted or imported the dates and Excel is confused about the format. Format cells and selecting dd/mm or dd/mmm/yy ofn doesn't work. Best way I've found to get Excel unconfused is to 1. select the text to be filled and then paste values or 2. select the Use Text wizard option when you paste. 3. Sometimes the Error box allows changing to dates but that's usually for numbers stored as text. |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
![]() |
creb1099 | Word VBA | 2 | 10-18-2013 10:19 AM |
auto fill a word doc from another program | hcubed | Office | 0 | 06-19-2013 09:42 PM |
![]() |
Kinar | Excel | 3 | 05-14-2013 07:46 AM |
Question about auto-fill form | Dsp581 | Word | 3 | 04-04-2013 11:27 PM |
Prompts to auto-fill name of contacts | crystaldb | Office | 4 | 05-21-2011 06:16 PM |