how do i get zeros to show after decimal point?
 

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!

how do i get zeros to show after decimal point?
 

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
"gwreed" wrote in message
...
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!

how do i get zeros to show after decimal point?
 

=TEXT(A2,"0.00")
Otherwise, use the field formatting functions within Word.
--
David Biddulph

"gwreed" wrote in message
...
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!