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

Do you think manufacturers should do more to reduce phone and tablet usage among kids?

Discuss in The Lounge

Poll History