Formula entry using "+" causing format errors
I had to try this for myself
never would believe it otherwise.
odd, but of course +123/6 is usually entered as =123/6
so I can only assume its treating the + as some sort of accounting code.
odd bearing in mind accounting doesn't usually invlove fractions :)
On Fri, 02 Feb 2007 14:54:00 -0000, 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 (3)
|