[Stefan Blom[_3_]]

You probably confused ;''" at the end (semi-colon, two single quotation
marks, double quotation mark) with ;"" (semi-colon, two double quotation
marks).

--
Stefan Blom
Microsoft Word MVP



"JOHABE" wrote in message
...
hello, I read this under the topic "How to get a formula field to total an
entire table column, even if some cells in the column contain text or are
blank" on the MVP-site and can't get it to work. I'm interested in the
final
bit, using ;""
Does anyone know how to do this?

start quotation...

Then in the total cell, press Ctrl+F9, and within the field braces {},
insert the following formula:

{ SUM(Table1 F:F) \# "#,##0.00;- #,##0.00;''" }

"Table1" in the formula refers to the name of the bookmark you've marked
the
main table with. The formula, being in a different table from the column
it's
totalling, wouldn't know which table you were referencing otherwise. The
F:F
bit means the 6th column from the left.

The bit at the end of the formula:

;''"

... means that if there are no values in column F, don't display anything
(otherwise it would display 0.00). I learnt that trick from Word MVP Cindy
Meister.

...end quotation

--
A professional template builder