A
ashbo
when formulas are set to add a column of currency, the result is more than
what it should be. when there is zero dollars in a cell, some are listed as
$ and others are listed as $ 0.00 and others are $0.00. the ones that
are $ 0.00 and $0.00 are the ones that are causing the error because when i
take them out, the column adds correctly. i've tried to change by going into
style and modifying but nothing seems to work. please help!!
what it should be. when there is zero dollars in a cell, some are listed as
$ and others are listed as $ 0.00 and others are $0.00. the ones that
are $ 0.00 and $0.00 are the ones that are causing the error because when i
take them out, the column adds correctly. i've tried to change by going into
style and modifying but nothing seems to work. please help!!