View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default Formula doesn't work unless hit enter again

Try selecting all the cells
Edit|Replace
What: = (equal sign)
with: =
replace all

Maybe it'll wake up excel's calculation engine.

Bobby wrote:

I have to select Each cells with a function, than put my cursor in the
formula bar and press enter. The excel option 'automatic calculation' is on
and was always on before? Also, all cells are in 'numbers' format...not text.
Thanks !


--

Dave Peterson