filling down a formula using =TEXT()

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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)
 
Thanks alot man that did the trick

PCLIVE said:
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
Click to expand...
 
Back
Top