Re: putting numbers in merged document

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

Hi =?Utf-8?B?Z3JlZWtoYXdrMTk1Mw==?=,

I am trying to put numbers into a merged document, actually dollars and
cents. The result are not showing the dollar sign ($) and the decimals is
wrong. How do I correct this.

Which version of Word are you using, and what's the data source? Excel?
Access? Something else?

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Jun 17 2005)
http://www.word.mvps.org

This reply is posted in the Newsgroup; please post any follow question or
reply in the newsgroup and not by e-mail :-)

.

Relevant Pages

  • Re: calculaton and accuracy issue
    ... though you may have changed the display of the cells to two decimals ... > 2nd column entered by a formula to calculate 15% of gross ... > the third column is off by a few cents on most of the line ...
    (microsoft.public.excel.worksheet.functions)
  • Re: Need help rounding off my dollar amount
    ... I want a function to round off my dollar value. ... > had ideas of isolating the cents, tens of cents and dollar values. ... Truncate decimals ... T_Currency_1 -- test of dollar and cents rounding. ...
    (borland.public.delphi.language.objectpascal)
  • Re: Convert currency to general
    ... Then I guess you will have use the multiply by 100 trick before formatting ... 111 = one dollar eleven cents ... and I strip off the decimals leaving 250 ... I need to export information from my AP application to my bank. ...
    (microsoft.public.excel.worksheet.functions)
  • Re: Converting Number To Text
    ... I started fiddling with an option to return either as moeny or straight ... decimals got complicated: ... Twenty Three Dollars and Five Cents", but as a decimal would be ... > Thanks Matt ...
    (comp.databases.filemaker)
  • Re: showing decimals query
    ... MS Access MVP ... The querey in question is trying to make a ... Eg I have 3 items all showing the value of 0.250 so the count record ... shows the record to 3 decimals but the addition is wrong. ...
    (microsoft.public.access.queries)