View Single Post
  #2   Report Post  
Dave Peterson
 
Posts: n/a
Default

After the number turns positive, what do you see in the formula bar for that
cell?

If it still shows negative there, then maybe it's just a formatting problem.

Format|cells|number tab|make it general.

If it really shows positive, then it sounds like you may have a macro that's
helping out.

Can you reopen your workbook with macros disabled and see what happens?

Jerri wrote:

When I try to enter a negative number into excel, the number turns positive
as soon as I enter it. I have tried deleting book1.xlt to remove any bogus
formatting but this problem appears to be some sort of default setting that I
do not know about.


--

Dave Peterson