Formula entry using "+" causing format errors
try it with = then - same thing
Steve
On Fri, 02 Feb 2007 15:06:02 -0000, JLatham <HelpFrom Jlathamsite.com.
wrote:
Formulas in Excel start with the = symbol. That's the basic rule.
"Steve" wrote:
When I enter a division formula by starting with a + sign. I get
strange
formating results.
1. enter the formula "+547/5" in a cell
2. change the format of that cell to accounting
3. reenter the formula
The format gets changed to a fraction and the formula is converted to a
number.
What's happening?
|