Re: display formula instead of its values in some cells

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

yes, but I am sure this is not the cause of the problem. Thanks.

"Bob Phillips" <bob.phillips@xxxxxxxxxxxxxxxxxxxx> ¼¶¼g©ó¶l¥ó·s»D:OaRePesEGHA.1028@xxxxxxxxxxxxxxxxxxxxxxx
> Check Tools>Options>View and make sure that Formulas is not checked.
>
> --
> HTH
>
> Bob Phillips
>
> (remove nothere from email address if mailing direct)
>
> "ah 3" <ah3@xxxxxx> wrote in message
> news:%23YlS5OsEGHA.1816@xxxxxxxxxxxxxxxxxxxxxxx
>> Hello all,
>>
>> I encountered problem for some excel files when typing a formula but
>> displayed a formula instead of its calculated values, e.g.
>>
>> when I entered "=100 + 100", what I exepected is to display as "200", but
> it
>> was displayed as "=100 + 100" instead.
>>
>> Please kindly help, many thanks!
>>
>>
>
>


.

Relevant Pages

  • display formula instead of its values in some cells
    ... I encountered problem for some excel files when typing a formula but ... Prev by Date: ...
    (microsoft.public.excel.worksheet.functions)
  • Re: Bug in the MILTER documentation
    ... > on a semaphore or some condition variable) so that the threads are ... Sorry for my typing, this was meant to say that since all worker threads ... Prev by Date: ...
    (comp.mail.sendmail)
  • Re: Random Function
    ... Is it "too much typing for you" perhaps, ... is there some other reason you don't like it? ... Mike ... Prev by Date: ...
    (comp.lang.basic.visual.misc)
  • How do I stop tables in Word from corrupting?
    ... rebuilding all the table and typing in all ... Does anyone have any clues? ... Prev by Date: ...
    (microsoft.public.word.tables)
  • Re: fields or properties
    ... my brain thinking of what I was typing. ... Prev by Date: ...
    (microsoft.public.dotnet.languages.csharp)