filling down a formula using =TEXT()
 

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?

filling down a formula using =TEXT()
 

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?

filling down a formula using =TEXT()
 

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?

filling down a formula using =TEXT()
 

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?

filling down a formula using =TEXT()
 

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?