If you type =1/3/4, that means to divide 1 by 3, then divide the result by 4,
i.e. 1/12 = 0.8333. If you want a date, you DON'T normally precede it with an
equal sign.
On Wed, 2 Feb 2005 11:23:05 +0530, "R.VENKATARAMAN"
$$$ wrote:
type in any cell
=1/3/04
take mouse toright hand bottom which turn into a +sing.
drag it down
I hope you mean jan 3, jan 4 etc.
Carol wrote in message
...
I need to a formula that would produce in column A a running series of
dates
without having to type them in individually. I need it such as (not
necesarily in numerical form):
1/03/2004
1/04/2004
1/05/2004
etc....
Thank you for any help!
|