Reply
 
Thread Tools Display Modes
  #1   Report Post  
Posted to microsoft.public.word.mailmerge.fields
DeeDeeCee DeeDeeCee is offline
external usenet poster
 
Posts: 41
Default Formatting a field result in Word

I have a table that I use--it has a column of figures which in the last box I
tally. I use Word's feature where you can insert a field like this:
{=sum(c1:c6)}

IF there are no cents in the column, it returns a number like this: 760
But I would like to return it in this format: 760.00, or even better: $760.00

Can someone clear up for me if I can add some switches or other formatting
to the field to make the number turn out this way?

Thanks.

ddc
  #2   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Doug Robbins - Word MVP Doug Robbins - Word MVP is offline
external usenet poster
 
Posts: 8,832
Default Formatting a field result in Word

See "Formatting Word fields with switches" on fellow MVP Graham Mayor's
website at:

http://www.gmayor.com/formatting_word_fields.htm


--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP, originally posted via msnews.microsoft.com
"DeeDeeCee" wrote in message
...
I have a table that I use--it has a column of figures which in the last box
I
tally. I use Word's feature where you can insert a field like this:
{=sum(c1:c6)}

IF there are no cents in the column, it returns a number like this: 760
But I would like to return it in this format: 760.00, or even better:
$760.00

Can someone clear up for me if I can add some switches or other formatting
to the field to make the number turn out this way?

Thanks.

ddc


Reply
Thread Tools
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Keeping symbol field result with text Jules Microsoft Word Help 1 May 22nd 08 09:41 AM
copy a field result into a footer of a document Anne Goss Microsoft Word Help 9 July 11th 07 01:24 PM
keeping a field result with text Jules Microsoft Word Help 4 November 10th 05 09:37 PM
Result in form field to generate comment in next field Phil Coates Microsoft Word Help 2 November 2nd 05 08:16 AM
how do I control formatting of "insert address" result in Word? Robert Tregear Microsoft Word Help 0 September 30th 05 09:29 AM


All times are GMT +1. The time now is 11:51 PM.

Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 Microsoft Office Word Forum - WordBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Word"