View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
SteveW SteveW is offline
external usenet poster
 
Posts: 427
Default 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)