98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Excel Training and help » microsoft excel training day courses near kent - Changing dates
microsoft excel training day courses near kent - Changing dates
Resolved · Low Priority · Version Standard
Wed 5 Dec 2007, 09:54Delegate Ron said...
Ron has attended:
Excel Introduction course
Word Intermediate course
Changing dates
how do I get a range of dates to work in seperate cells? i.e. 5th - 8th december 2007
Fri 7 Dec 2007, 17:08Trainer Katie said...
RE: changing dates
Hi Ron,
Please could you elaborate your question. What do you mean by work?
If you want to autofill dates, click on the bottom right corner of the first cell [AutoFill Handler] and drag down/across to other cells. For example:
Cell A1 = 05/12/07;
Cell A2 = 06/12/07;
Cell A3 = 07/12/07
Let me know if this solution is sufficient.
Regards,
Katie
Training information:
See also:
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel tip:Bracketed negative numbersOften Excel users wish to display negative numbers in colour red and bracketed |
