A co-woorker sent me a spreadsheet saying that she couldn't total a
column of numbers. It is formatted for "Accounting, 2 decimal places",
but it doesn't show zeros to the right of the decimal place. It treats
the column like it was text when I try to sum it. I have tried
everything like inserting a new column and doing a special paste to
just put in the values and formating it and I get the same result. The
sheet isn't protected or anything like that. Any ideas?


--
tallyman00
------------------------------------------------------------------------
tallyman00's Profile: http://www.excelforum.com/member.php...o&userid=29971
View this thread: http://www.excelforum.com/showthread...hreadid=502879