View Single Post
  #4   Report Post  
Myrna Larson
 
Posts: n/a
Default

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!