If you select the cell (when you see the dash), then look at the number
formatting, what do you see?



Mac wrote:

I see the actual formula in the formula bar. If I change any part of the
formula and hit enter, it populates the cell with a dash.

Changing format doesn't work...thanks.
--


Mac

"Dave Peterson" wrote:

What do you see in the formulabar?

How about changing that cell's numberformat to General?
Format|Cells|Number tab

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

--

Dave Peterson


--

Dave Peterson