View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Sean Timmons Sean Timmons is offline
external usenet poster
 
Posts: 1,696
Default Getting a dash wjen updating a formula

Go to Tools - AutoCorrect Options and ensure you don't have 9 to be replaced
with -. If you do, click on that row and delete.

"Mac" wrote:

Hi,

Excel 2003 - When I try to update a formula in a cell and hit enter, it
gives me a dash instead of the result of the formula.

Original = = 5 + 5 Cell = 10
Update = = 5 + 4 Cell = -

Any ideas?
--


Mac