A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Word » Tables
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

How format numbers resulting from 'math' formulas in WORD tables?



 
 
Thread Tools Display Modes
  #1  
Old January 2nd, 2009, 02:06 AM posted to microsoft.public.word.tables
mkraft
external usenet poster
 
Posts: 50
Default How format numbers resulting from 'math' formulas in WORD tables?

How can I get 'table math' computations (i.e., numbers returned from
'formulas') in WORD tables to be formatted the way I want them to? -- e.g.,
to include a 'following zero' (e.g., 70.10 instead of 70.1) and commas in
thousands (6,863.63 instead of 6863.63) - ?

Thanks.
  #2  
Old January 2nd, 2009, 03:59 AM posted to microsoft.public.word.tables
Suzanne S. Barnhill
external usenet poster
 
Posts: 31,786
Default How format numbers resulting from 'math' formulas in WORD tables?

You need a "numeric picture switch." See this topic in help or
http://www.gmayor.com/formatting_word_fields.htm

--
Suzanne S. Barnhill
Microsoft MVP (Word)
Words into Type
Fairhope, Alabama USA
http://word.mvps.org

"mkraft" wrote in message
news
How can I get 'table math' computations (i.e., numbers returned from
'formulas') in WORD tables to be formatted the way I want them to? --
e.g.,
to include a 'following zero' (e.g., 70.10 instead of 70.1) and commas in
thousands (6,863.63 instead of 6863.63) - ?

Thanks.



  #3  
Old January 2nd, 2009, 04:11 AM posted to microsoft.public.word.tables
Jay Freedman
external usenet poster
 
Posts: 9,488
Default How format numbers resulting from 'math' formulas in WORD tables?

On Thu, 1 Jan 2009 17:06:00 -0800, mkraft
wrote:

How can I get 'table math' computations (i.e., numbers returned from
'formulas') in WORD tables to be formatted the way I want them to? -- e.g.,
to include a 'following zero' (e.g., 70.10 instead of 70.1) and commas in
thousands (6,863.63 instead of 6863.63) - ?

Thanks.


Look at the help topic "Numeric Picture (\#) field switch". For the examples you
give, the field might look like

{= SUM(ABOVE) \# #,###.00}

Note: If you have regional settings that use a dot as the thousands separator
and a comma as the decimal point, they should also be swapped in the picture
switch.

--
Regards,
Jay Freedman
Microsoft Word MVP FAQ: http://word.mvps.org
Email cannot be acknowledged; please post all follow-ups to the newsgroup so all may benefit.
  #4  
Old January 2nd, 2009, 07:07 AM posted to microsoft.public.word.tables
macropod[_2_]
external usenet poster
 
Posts: 2,402
Default How format numbers resulting from 'math' formulas in WORD tables?

Hi mkraft,

In addition to the helpful suggestions provided by Suzanne and Jay, you might like to check out my Word Field Maths 'tutorial', at:
http://www.wopr.com/cgi-bin/w3t/show...?Number=365442
or
http://www.gmayor.com/downloads.htm#Third_party
In particular, look at the item titled 'Formatting Numeric Field Results'.

--
Cheers
macropod
[MVP - Microsoft Word]


"mkraft" wrote in message news
How can I get 'table math' computations (i.e., numbers returned from
'formulas') in WORD tables to be formatted the way I want them to? -- e.g.,
to include a 'following zero' (e.g., 70.10 instead of 70.1) and commas in
thousands (6,863.63 instead of 6863.63) - ?

Thanks.

  #5  
Old January 4th, 2009, 07:10 PM posted to microsoft.public.word.tables
mkraft
external usenet poster
 
Posts: 50
Default How format numbers resulting from 'math' formulas in WORD tabl

You need a "numeric picture switch." See this topic in help or
http://www.gmayor.com/formatting_word_fields.htm


Thanks but that (the linked webpage) looks like pretty heavy-duty reading.
Isn't there a more simple way of selecting these options for number formats?
I mean, this is not anything arcane -- wanting 'thousands' numbers to include
commas, and 'decimal places' to display two numbers right of the decimal
point (even if the rightmost number is a zero).
  #6  
Old January 4th, 2009, 07:27 PM posted to microsoft.public.word.tables
Suzanne S. Barnhill
external usenet poster
 
Posts: 31,786
Default How format numbers resulting from 'math' formulas in WORD tabl

I believe another poster provided the exact switch you need, which you can
also find in Word's Help file, as indicated. The basic switch information
(reproduced and edited from Word's Help) is at the bottom of Graham's
article. The Numeric Picture (\#) field switch is the one you want.

--
Suzanne S. Barnhill
Microsoft MVP (Word)
Words into Type
Fairhope, Alabama USA
http://word.mvps.org

"mkraft" wrote in message
...
You need a "numeric picture switch." See this topic in Help or
http://www.gmayor.com/formatting_word_fields.htm


Thanks but that (the linked webpage) looks like pretty heavy-duty reading.
Isn't there a more simple way of selecting these options for number
formats?
I mean, this is not anything arcane -- wanting 'thousands' numbers to
include
commas, and 'decimal places' to display two numbers right of the decimal
point (even if the rightmost number is a zero).



  #7  
Old January 4th, 2009, 10:19 PM posted to microsoft.public.word.tables
macropod[_2_]
external usenet poster
 
Posts: 2,402
Default How format numbers resulting from 'math' formulas in WORD tabl

Hi Suzanne,

Perhaps the simplest construction that wiuld suit the OP's needs is somthing along the lines of:
{= SUM(ABOVE) \# ,0.00}

I agree, though, that learning how to use the formatting switches is better than simply taking whatever you're given without
bothering to understand it.

--
Cheers
macropod
[MVP - Microsoft Word]


"Suzanne S. Barnhill" wrote in message ...
I believe another poster provided the exact switch you need, which you can also find in Word's Help file, as indicated. The basic
switch information (reproduced and edited from Word's Help) is at the bottom of Graham's article. The Numeric Picture (\#) field
switch is the one you want.

--
Suzanne S. Barnhill
Microsoft MVP (Word)
Words into Type
Fairhope, Alabama USA
http://word.mvps.org

"mkraft" wrote in message ...
You need a "numeric picture switch." See this topic in Help or
http://www.gmayor.com/formatting_word_fields.htm


Thanks but that (the linked webpage) looks like pretty heavy-duty reading.
Isn't there a more simple way of selecting these options for number formats?
I mean, this is not anything arcane -- wanting 'thousands' numbers to include
commas, and 'decimal places' to display two numbers right of the decimal
point (even if the rightmost number is a zero).




  #8  
Old January 5th, 2009, 01:42 AM posted to microsoft.public.word.tables
mkraft
external usenet poster
 
Posts: 50
Default How format numbers resulting from 'math' formulas in WORD tabl

I agree, though, that learning how to use the formatting switches is better
than simply taking whatever you're given without bothering to understand it.

That's not really the point. This is word processing and a word processing
program should have certain features available in menus or submenus because
they are standard features of such programs. The user should not have to
construct formulas to do such simple and basic operations.

  #9  
Old January 5th, 2009, 01:45 AM posted to microsoft.public.word.tables
mkraft
external usenet poster
 
Posts: 50
Default How format numbers resulting from 'math' formulas in WORD tabl

Look at the help topic "Numeric Picture (\#) field switch". For the
examples you
give, the field might look like

{= SUM(ABOVE) \# #,###.00}


Thanks. Why is there a space between the first two '#' characters?
  #10  
Old January 5th, 2009, 01:51 AM posted to microsoft.public.word.tables
mkraft
external usenet poster
 
Posts: 50
Default How format numbers resulting from 'math' formulas in WORD tabl

In addition to the helpful suggestions provided by Suzanne and Jay, you
might like to check out my Word Field Maths 'tutorial', at:
http://www.wopr.com/cgi-bin/w3t/show...?Number=365442
or
http://www.gmayor.com/downloads.htm#Third_party
In particular, look at the item titled 'Formatting Numeric Field Results'.


Thanks, I wonder, though, what percentage of Word users would agree that it
should be necessary to navigate such tutorials in order to do the simple
things I inquired about.

 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 02:53 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.