Why does a formula then I type it sometimes change directly to the result.

Do you have a helpful macro that's doing it?



Excel 2003 - SPB wrote:

Why does a formula then I type it sometimes change directly to the result.

--

Dave Peterson

No Macros only VBA based to buttons toactivate and run Forms, another strange
thing, numbers on the displayed forms are displaying long decimals ie.
3.39999999 when the result should be 3.4.. I was trying to use a form to
popup and show some results of a calculation.

"Dave Peterson" wrote:

Do you have a helpful macro that's doing it?



Excel 2003 - SPB wrote:

Why does a formula then I type it sometimes change directly to the result.

--

Dave Peterson

I'd check again for a macro.

If you close excel and reopen it in safe mode:

Close excel
windows start button|Run
excel /safe
file|Open yourworkbook.xls

Do you still have the same problem of formulas getting converted to values?

I bet you have some code causing the trouble. It may be in one of the addins
that's loaded if it's not in your workbook.

I'd start looking for "helpful" addins that get loaded when excel starts
normally.

Chip Pearson has some notes on how to diagnose startup errors at:
http://www.cpearson.com/excel/StartupErrors.htm

And Jan Karel Pieterse has more notes at:
http://www.jkp-ads.com/Articles/StartupProblems.asp

===
As for 3.4 showing up 3.99999999999999, excel suffers from rounding errors--just
like any other program that does things in binary.



Excel 2003 - SPB wrote:

No Macros only VBA based to buttons toactivate and run Forms, another strange
thing, numbers on the displayed forms are displaying long decimals ie.
3.39999999 when the result should be 3.4.. I was trying to use a form to
popup and show some results of a calculation.

"Dave Peterson" wrote:

Do you have a helpful macro that's doing it?



Excel 2003 - SPB wrote:

Why does a formula then I type it sometimes change directly to the result.

--

Dave Peterson


--

Dave Peterson