microsoft excel training day courses near kent - changing dates

Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

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

resolvedResolved · Low Priority · Version Standard

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

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


 

Excel tip:

Bracketed negative numbers

Often Excel users wish to display negative numbers in colour red and bracketed

Intstructions
Step1. Select Format > Cells menu options. Within Numbers tabsheet, select Category = Custom.
Step 2. Select a type such as #,##0;[Red]-#,##0;; that specifies a colour in square brackets.
Step 3. Amend as follows; #,##0;[Red](#,##0;;

Notes: Excel formatting featues are of the form
"Positive; Negative;Zero;Text" separated by semicolon.

View all Excel hints and tips


Server loaded in 0.08 secs.