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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel 2003 - fill down error 1
Using text in a cell in a formula 2
Import data, fill adjacent formulas 1
Formulas won't increment when dragging to adjacent cells? 3
Macro to extend formulas 4
Excel VBA 1
Fill formula down for cells 74 rows apart 3
Fill down formulas in existing excel docs stopped working 1

Back
Top