View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Marcelo Marcelo is offline
external usenet poster
 
Posts: 1,047
Default Basic format problem

hi Ray,

try:

1. check if the cell is formated as text, format it as general and try again.

2. Tools | Options | exibity box and uncheck formula

hth
--
regards from Brazil
Thanks in advance for your feedback.
Marcelo



"Ray" escreveu:

This has driven me insane for years! I type =a14+a15 and the cell display is
=a14+a15. Instead of treating it as a function and providing a result I only
see the formula displayed as text within the cell. The above calc was just a
sample and I usually find a way around it but this happens to me more and
more often. Any help would be appreciated..


--
Ray