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
|