View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Dave F Dave F is offline
external usenet poster
 
Posts: 2,574
Default 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