How do I show zeros transfered from excel to mail-merge word?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Okay, I have made my one of columns in Excel as currency, and when I
transfer that data over to mail-merge word to print my letters, it only shows
the value of $74.40 as $74.4. What do I need to do?
 
One way would be to format the currency column as text. That way, whatever is
in the cell will be transferred.
 
But formatting as text a column which is currently formatted as currency
will *not* keep the formatting of the data currently displayed. Your
$74.40 would change to 74.4. You'd be better off with a helper column such
as =TEXT(A1,"$0.00").
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Merge Problems 1
Excel Word Mail Merge 8
how do i get zeros to show after decimal point? 2
Can't merge info from Excel onto address labebls 1
Import data from Word 1
Convert number to text as displayed 3
How do you merge a dollar amount into a word doc and keep the $? 1
Using formula-generated figures in excel in mail-merging 1

Back
Top