filling down a formula using =TEXT()

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

PCLIVE

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
 
P

Peo Sjoblom

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)
 
G

Guest

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

Using text in a cell in a formula 2
formula to count text entries and return text with most entries 8
Custom filling of cells 2
Automatically Enter Formula in a Cell After Entering Data in Another Cell 0
Fill down formula not cell content 5
How do I reference a cell as a row number in a formula? 4
Autofiltering then filling down numbers. 5
Use first day of month formula in a drop down list 3

Top