G
Guest
I have a four column worksheet - col A contains text for descriptions, cols b
thru d contain comma formatted numbers - 2 decimal places, the worksheet has
about 30 rows of data. When summing col b thru d the total for each column
should be zero, the row totals can be various amounts. The problem is col b
shows 0.00, but cols c and d show - (dashes) representing zero. This has
happened randomly to several worksheets over the years. I've tried
reformatting columns, formatting tool, but can't seem to get rid of the 0.00.
Any help would be appreciated.
Thanks,
thru d contain comma formatted numbers - 2 decimal places, the worksheet has
about 30 rows of data. When summing col b thru d the total for each column
should be zero, the row totals can be various amounts. The problem is col b
shows 0.00, but cols c and d show - (dashes) representing zero. This has
happened randomly to several worksheets over the years. I've tried
reformatting columns, formatting tool, but can't seem to get rid of the 0.00.
Any help would be appreciated.
Thanks,