View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
JE McGimpsey JE McGimpsey is offline
external usenet poster
 
Posts: 4,624
Default Calculation value displays in formula

If it's only one workbook, I'd strongly suspect you have an event macro
running (in your ThisWorkbook code module), though why it would be set
up to do that, I don't know.

The only other way I know of to accomplish that transformation is to
highlight the 900/3 and press F9...

Don't know anything about "pages" - newsgroups don't have them and most
newsreaders don't display in pages. But you're probably reading news via
a much clunkier web portal...


In article ,
Sandy wrote:

The entry +2*5*3 yields the correct result of 30. The problem is when I
click on the cell I cannot see my original entry - instead it shows =10*3.
The entry +900/3*4 returns the correct result of 1200, however, when I click
on the cell it shows =300*4. Any entry with only 2 components works fine.
This is the only workbook that does this, however, it does it on all sheets.
As an accountant, in Excel, I have always used the + sign instead of the =
sign because it is so much faster and more intuitive.

I am sorry about posting on 2 different boards. The first posting was
already on page 3, and the only response was a question, which I had then
answered, and figured had probably been forgotten.