View Single Post
  #3   Report Post  
Frank Kabel
 
Posts: n/a
Default

Hi
for me the value in the formula bar remains unchanged

--
Regards
Frank Kabel
Frankfurt, Germany

"MHoffmeier" schrieb im
Newsbeitrag ...
When I type an arithmetic formula into a cell, excel automatically

condenses
it. For instance, =3/27 becomes =.1111111. I am not referring to

the
displayed value, but the actual entry in the cell. How can I turn

this
"feature" off? It is important, because when I return to the sheet

months
later, the full formula helps me to remember how I decided to

calculate the
result.