"Lauren" wrote in message
...
I used one of the excel templates from the office online website. I changed
a
all of the column and row headings to labels that were relevant to what I
needed to do.... I finished it and saved as a template in 'Save As'. Now,
when I copy and paste that information/template to another workbook all
the
empty cells become zeros with the cell format of that column from the
template...for example...$0 or 0.00 I've tried clearing the
contents..but
there's nothing there to clear on the template- only on the new workbook
that
I create.
What do I do??
--


Try File - New- My templates - Create (at least that's the procedure in
2007). That's what you are supposed to do, not copy and paste.