how do i get zeros to show after decimal point?

G

gwreed

I have an excel file that I am using for a mail merge. I need the numbers in
the excel file to come into the Word doc with zeos after the decimal to show
as dollar amounts. When I do the merge it just shows as "2" (or whatever the
number is), and I need it to show as "2.00". I have tried every formatting
technique I can think of, and it won't accpt it. It shows fine in the Excel
cell, but not in the formula bar or the in the merge to Word.

Thanks for your help!
 
C

Cimjet

Have you tried formating as Text, just type an apostrophe < ' > before your
number, this will change the format from numbers to text and should keep
your zeros.
Regards
Cimjet
 

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
Convert number to text as displayed 3
Numbers after decimal point excel to word mail merge 1
why do zeros after decimals drop out of excel 3
How do you merge a dollar amount into a word doc and keep the $? 1
Decimal point in general format 1
How do I show zeros transfered from excel to mail-merge word? 3
Merge data from xcel to word 3

Top