View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
gwreed gwreed is offline
external usenet poster
 
Posts: 1
Default 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!