remove a dash in my column

[Guest]

I added a new row and some of the colums should have a 0.00 balance.
However, instead of the 0.00 I get a - and cannot remove it and replace it
with 0.00. How can I get rid of this - (dash) and get my zero's back.

 

[Don Guillett]

That is 0. Change your formatting from accounting

 

[Dave Peterson]

How about just formatting the cells the way you like:

Select the range
format|Cells|Number tab|and change to Number (2 decimal places)???

 

[Clarence Crow]

I added a new row and some of the colums should have a 0.00 balance.
However, instead of the 0.00 I get a - and cannot remove it and replace it
with 0.00. How can I get rid of this - (dash) and get my zero's back.

That will be a Custom Format someone has set on your Number Format.
Just Format Cell/Number/Decimal Places/2.
NB: At bottom of panel, you can Format for appearances of Negative
Numbers and Colors.

-Please reply to group as my email addr is fake!

-Regards CC

 

[Gord Dibben]

You are formatted to Accounting.

Change from Accounting format to just Number format with 2 DP or to Currency
format which is 2 DP with a Currency symbol.


Gord Dibben MS Excel MVP

 

[Guest]

Gord: I am doing accounting. The dash is only one one or two rows. All
other rows are ok. I don't understand why I got the dash when I was just
updating some figures. Irene