So if i get you correctly you want to paste special without actually using
paste special??? For this particular spread sheet the destination formatting
always superceeds the incoming formatting. If that is the case then you are
out of luck.

Cells are self contained items that hold formulas, values, formats, etc...
When you copy them you get the whole thing. When you paste them (short of
using paste special) you paste the whole thing... That is not a feature that
can be overridden for a specific workbook or for a specific cell... What you
can do is to put the paste special buttons right on your tool bar and use
those buttons to speed up the paste special process.

The other option is to change your template to have two seperate sheets. One
is a data entry sheet where you put your values or formulas organized in a
way that is maximised for ease of entry. The format of the data on this sheet
is not important. The values from that sheet are processed onto an output
sheet (in your case the required finacial statement) which is formatted just
the way you want it. There is never any data entry on the output sheet. It is
entirely formula driven. A good analogy would be Tax prep software where they
ask you to fill in a bunch of info on a data enty sheet and then they use
that info to populate a pre-formatted tax form.
--
HTH...

Jim Thomlinson


"RogueBiscuit" wrote:

Thanks for your response. I know how to do that. I'm looking for something
a little different.

I work in finance and use financial statements all day. I have a "shell"
template for income statements and the like. I want to lock the formatting
of the shell (meaning borders, bolding, font size and such) and be able to
put data in without doing PasteSpecial.

"CLR" wrote:

Copy PasteSpecial Values, or Copy PasteSpecial Formulas, either
should leave the formatting intact...........

hth
Vaya con Dios,
Chuck, CABGx3



"RogueBiscuit" wrote:

When I put together spreadsheet I often have formatting that I would like to
be static. Then I can copy and paste values and formulas from other cells in
the worksheet without altering the format in the destination cell. Can
anyone help me do this? Thanks

Andrew