Hi, I am using excel 2002 as part of office 2002. I have a formula for adding columns(vertical) of rows(horizontal). Row 1 will be totalled at the last column. Along the way though the enitre row will not be added together, only parts of it. I have excluded these variablies from the formula. They are just for inventory. So now my problem is, the ones the are added together have the syntax of currency eg. 5.00 meaning five dollars. But the columns that are only inventory would have just a plain non-decimal figure eg. 5 for five items. The problem is that the inventory items are still in currency format eg. 5.00 instead of just 5 I know how to fix it but I must do it every time for every column. What am I doing wrong? It used to work fine in the old office, (but the old office may have been preconfigured with a template?) The bracketed area is really a question. Do I need a spreadsheet template? The formula stays from sheet to sheet/month to month. Please help as this is very annoying.

have you tried saving thid as a template after changing the inventory's format? it might work.