Prev: What causes the keyboard arrows to move the page, not the cell?
Next: Open a file without using Office Live?
From: "David Biddulph" groups [at] on 10 Mar 2010 02:49
That doesn't put the right format into a mailmerged document or a
concatenated formula, Russell.
You need the TEXT function in Excel, or in MS Word mailmerge you could use
Word's field formatting functions.
--
David Biddulph


"Russell Dawson" <russell.dawson(a)discussions.microsoft.com> wrote in message
news:4F5A3A84-EF5F-4218-A1C7-14111A60AD58(a)microsoft.com...
> Hi Krissy
>
> It looks like you are importing the value from an Excel w/sheet into a
> mailmerged document.
>
> To have the value in the w/s appear as $x.xx you need to format the cell
> as
> currency.
> Right click the cell - format cells - currency - select symbol $ US - OK
>
> --
> Russell Dawson
> Excel Student
>
> Please hit "Yes" if this post was helpful.
>
>
> "krissy" wrote:
>
>> "We have been asked to contact you by our client 0, regarding your
>> past due invoice for 7896.98. Their records indicate that payment has
>> not been received as of the date of this correspondence, and is therefore
>> listed for collection. This balance may include finance charges. "
>>
>>
>> How do I make the 7897.98 w/ a dollar amount? The current formula is " &
>> c8
>> & ".
>>
>> Please HELP!!!


First  |  Prev  | 
Pages: 1 2
Prev: What causes the keyboard arrows to move the page, not the cell?
Next: Open a file without using Office Live?