M
MattWright
OK, so I have a document where there is a table with text entry fields
Column 1 is Qty, Column 2 is Item description (nothing to do with m
problem), Column 3 Unit Price, and Column 4 Line Price. There are appro
25 Rows that are identical. I have it set to multiply the Qty and Uni
Price Columns to get the Line Price Column. My problem is that my clien
does not want the $0.00 in the Line Price Column if there is no ite
using that row. I found where I can use the \# $#,##0.00;($#,##0.00)
formula to get this result, the only problem is the Total Price Field a
the bottom of the page. It will not calculate the total from thes
fields if I use this formula. I need to know, is there a way to mak
these $0.00 unprintable unless they are replaced by another number, o
is there a way to bypass the non-calculating blank field option o
another way to hide these $0.00 until they are filled in but stil
calculate as a zero for the Total Price field. My client only wants t
use MS Word, not Excel. Any help would be much appreciated
Column 1 is Qty, Column 2 is Item description (nothing to do with m
problem), Column 3 Unit Price, and Column 4 Line Price. There are appro
25 Rows that are identical. I have it set to multiply the Qty and Uni
Price Columns to get the Line Price Column. My problem is that my clien
does not want the $0.00 in the Line Price Column if there is no ite
using that row. I found where I can use the \# $#,##0.00;($#,##0.00)
formula to get this result, the only problem is the Total Price Field a
the bottom of the page. It will not calculate the total from thes
fields if I use this formula. I need to know, is there a way to mak
these $0.00 unprintable unless they are replaced by another number, o
is there a way to bypass the non-calculating blank field option o
another way to hide these $0.00 until they are filled in but stil
calculate as a zero for the Total Price field. My client only wants t
use MS Word, not Excel. Any help would be much appreciated