I am using =TEXT() formula to display the month as text from a numerical date
in an adjacent column. When I attempt to fill this formula down for the
subsequent rows, all the cells display the same month as the first cell where
I originally entered the formula. Is there some way of filling down so that
each cell is calculated correctly?

Press F9 to recalculate.
Do the formulas look correct? If not, then check to see if you have
something like
=TEXT(A$1,"mmmm")
If so, remove the "$" and then copy down again.

HTH,
Paul

"dxdallyn" wrote in message
...
I am using =TEXT() formula to display the month as text from a numerical
date
in an adjacent column. When I attempt to fill this formula down for the
subsequent rows, all the cells display the same month as the first cell
where
I originally entered the formula. Is there some way of filling down so
that
each cell is calculated correctly?

Change calculation to automatic under tools options calculation
or if you already have automatic calculation make sure needed cell
references are relative (no dollar signs for the row numbers)


--
Regards,

Peo Sjoblom


"dxdallyn" wrote in message
...
I am using =TEXT() formula to display the month as text from a numerical
date
in an adjacent column. When I attempt to fill this formula down for the
subsequent rows, all the cells display the same month as the first cell
where
I originally entered the formula. Is there some way of filling down so
that
each cell is calculated correctly?

Thanks alot man that did the trick

"PCLIVE" wrote:

Press F9 to recalculate.
Do the formulas look correct? If not, then check to see if you have
something like
=TEXT(A$1,"mmmm")
If so, remove the "$" and then copy down again.

HTH,
Paul

"dxdallyn" wrote in message
...
I am using =TEXT() formula to display the month as text from a numerical
date
in an adjacent column. When I attempt to fill this formula down for the
subsequent rows, all the cells display the same month as the first cell
where
I originally entered the formula. Is there some way of filling down so
that
each cell is calculated correctly?

No problem. Glad to help.


"dxdallyn" wrote in message
...
Thanks alot man that did the trick

"PCLIVE" wrote:

Press F9 to recalculate.
Do the formulas look correct? If not, then check to see if you have
something like
=TEXT(A$1,"mmmm")
If so, remove the "$" and then copy down again.

HTH,
Paul

"dxdallyn" wrote in message
...
I am using =TEXT() formula to display the month as text from a numerical
date
in an adjacent column. When I attempt to fill this formula down for
the
subsequent rows, all the cells display the same month as the first cell
where
I originally entered the formula. Is there some way of filling down so
that
each cell is calculated correctly?