View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Niek Otten
 
Posts: n/a
Default Problems with Excel functions

Your cell was formatted as text before entering the function.
Format as General and re-enter (F2, Enter)

--
Kind regards,

Niek Otten

"RITRAM" wrote in message
...
I have a problem with the excel funtions. The problem is that when write a
funtion as for example : = Replace(E2,12,16," ") what is displayed in the
cell is the funtion that i wrote and not the result. I have been having
this
problem and i do not know if it's a setting on my program. Please help me
on.....is URGENT... I need Excel working ....
Thanks in advance