Formula entry using "+" causing format errors
Don't use a + sign. Positive 547 divided by positive 5 need only be entered
as =547/7.
For negative numbers, you DO need to enter the sign: =-547/-7 etc.
Dave
--
A hint to posters: Specific, detailed questions are more likely to be
answered than questions that provide no detail about your problem.
"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?
--
Steve
|