View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
RogerN
 
Posts: n/a
Default Using Invoice template: overriding formulae

Don'y know how to override the original protectiion. Easiest would be to copy
and paste into new sheet and use this to create your own template.

Roger

"Enigmaman" wrote:

I am having a problem when using the Excel 2000 Invoice template. Sometimes I
enter text into the 'Quantity' column. Then Excel is unable to calculate the
Total, in the blue shaded area.

My question is: How do I override the formula calculation in the shaded area
to simply enter the numbers and/or text of my choosing?

WTIA

Andrew Stucken
--
Evil flourishes when good men do nothing.