Reply to thread

Message: [QUOTE="johnscpierce, post: 7409894"] I have some data that appears in cells as: $37,920.00, $719.45, $2,850,500.00. In the Formula Bar these numbers look like: 37920, 719.45, 2850500. The cells are formatted as Currency. What I would like is to capture the characters that make up the cell appearance. I know that this would change the numbers to text which is also desireable. The goal is to merge them into a Word mailing form. Is there a way to change these numbers into text with dollar sign, commas, and zeros in decimal places without retyping them? [/QUOTE]