Formula changing itself

  • Thread starter Thread starter Mike
  • Start date Start date
M

Mike

Here's a bit of a weird one.

I've got an excel sheet that's generated from a template, no macros / VB
code attached to it, and the cells I'm working with are all formatted as 1
decimal place numbers. I'm using WinXP, XL2000 SP3

If I go to a cell and just start typing "+5*2/20" without the quotes, so
that excel should put in the cell a formula of 5 times 2 divided by twenty
(for example, it's happened a few other times as well) , as soon as I hit
enter, if I go immediately back to that cell, the formula listed is "=5*0.1"
(again, without the quotes).

Now, obviously, the math is not all that complicated, nor is the value
wrong, but I'm entering the 5*2/20 so I can remember that the value comes
from 5 seconds each direction * walking 2 directions / every 20 pieces.

How & Why is excel changing my 2/20 to 0.1???

If "F2" and edit the formula (or highlight with the mouse and type over to
edit) the 0.1 back to 2/20, it sticks that time.

Has anyone seen this or know of what to do to stop it?



--

____________________________________________________________________________
________________
Please reply to newsgroup so everyone can benefit.
Email address is not valid (see sparkingwire.com)
____________________________________________________________________________
________________
 
First, I'm using xl2002 and I couldn't replicate what you got. xl always
converted the leading + to an equal sign.

And it left the fraction at the end.

But you may want to try typing = instead of + (former/current 123 user???)

And these didn't have an affect in xl2002, but you may want to check:
tools|options|transition
(Uncheck all the Lotus 123 options.)
 
Back
Top