Spreadsheet will be used to merge into Word document. The columns that contain formulas will not merge correctly. Is there a formula that I can apply to these columns to change them to text?

By "formulas" if you mean Math/Algebraic formulas try here:http://help.lockergnome.com/office/...

MIKE

Copy...PasteSpecial...Values This will replace the formula with the value that is displayed in the cell, i.e. the

of the formula.result

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.

Ask Your Question

Weekly Poll

Have you played Jackbox during the pandemic?

Discuss in The Lounge

Poll History