View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
PCLIVE PCLIVE is offline
external usenet poster
 
Posts: 1,311
Default 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?