how do i get zeros to show after decimal point?

  • Thread starter Thread starter gwreed
  • Start date Start date
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!
 
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
 
Back
Top