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?
|