View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
dxdallyn dxdallyn is offline
external usenet poster
 
Posts: 2
Default filling down a formula using =TEXT()

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?