On 7 Jul 2006 at 21:18, Clois Beckwith wrote:

> I have been using Microsoft Excel for 10 plus years and I can't quite
> figure out how to autofill in the following format:
> 
> Dec, 05
> Nov,05
> Oct,05
> etc.
> 

When I try this in Excel 97, I get

Dec, 06
Dec, 07
Dec, 08
etc

So its not just a case of Excel doing something that OOo cannot.

What you need is to define a custom format of 'xxx, 99'.  This is a 
numeric fomat, so the '05' will increment.  Of course, it will carry on to 
Dec 13!


Tony

---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]

Reply via email to