How do I remove the extra stuff in a Word Table cell (see Screenshot) so that only the numeric value is left.
Something like Replace(tbl.cell(r,c).Rang
uff I don't want","")
Screenshot of msgbox showing extra mark up that is causing the following script to err because it can not convert the number value in the cell to a CDbl. The values in the cells are numbers. Somehow Word adds bullet points and line breaks
.Text, "-","0")) - CDbl(Replace(tbl.cell(row-
.Text, "-","0")) ,0))
Here is a sample of the code that is populating the Cell in the first place:
ange.text = AccountingFormat(split(htt
AccountingFormat function is just replacing 0 with a - symbol.