Changing text cells to currency to autosum?
Posted by Chris on February 05, 2002 5:08 PM
Ok, here is my problem. My clients have sent in excel sheets where we need to sum the dollar amount to get the totals etc... Well this usually works out fine as most people have it formatted as something other then text (currency, number, etc..) that can be Auto-summed below the column.
The only way I know of to fix this problem is to highlight the column and change the format to currency and then re-key the entire column since if you dont re-key it will not accept the change in format, or at least I dont know of a way to make it accept those changes to format without doing this. As you might imagine, trying this with a 10 line template isnt bad but staring at a 4000 row template is a little un-nerving! hahaha Thanks in advance for any help!