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