Reply
 
Thread Tools Display Modes
  #1   Report Post  
Posted to microsoft.public.word.tables
mkraft mkraft is offline
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   Report Post  
Posted to microsoft.public.word.tables
Suzanne S. Barnhill Suzanne S. Barnhill is offline
external usenet poster
 
Posts: 33,624
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   Report Post  
Posted to microsoft.public.word.tables
Jay Freedman Jay Freedman is offline
external usenet poster
 
Posts: 9,854
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   Report Post  
Posted to microsoft.public.word.tables
macropod[_2_] macropod[_2_] is offline
external usenet poster
 
Posts: 2,059
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   Report Post  
Posted to microsoft.public.word.tables
mkraft mkraft is offline
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   Report Post  
Posted to microsoft.public.word.tables
Suzanne S. Barnhill Suzanne S. Barnhill is offline
external usenet poster
 
Posts: 33,624
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   Report Post  
Posted to microsoft.public.word.tables
macropod[_2_] macropod[_2_] is offline
external usenet poster
 
Posts: 2,059
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   Report Post  
Posted to microsoft.public.word.tables
mkraft mkraft is offline
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   Report Post  
Posted to microsoft.public.word.tables
mkraft mkraft is offline
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   Report Post  
Posted to microsoft.public.word.tables
mkraft mkraft is offline
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.



  #11   Report Post  
Posted to microsoft.public.word.tables
macropod[_2_] macropod[_2_] is offline
external usenet poster
 
Posts: 2,059
Default How format numbers resulting from 'math' formulas in WORD tabl

Hi mkraft,

There are so many possible formatting options, any attempt to reproduce them via a menu would be a monster - and would likely not
address everyones' needs. At some stage, users neede to get used to the idea of going beyond the menus and explore Word's Help
file - which tells you how to go about formatting field results which, I might add, is something very few Word users ever need to
do.

--
Cheers
macropod
[MVP - Microsoft Word]


"mkraft" wrote in message ...
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.


  #12   Report Post  
Posted to microsoft.public.word.tables
macropod[_2_] macropod[_2_] is offline
external usenet poster
 
Posts: 2,059
Default How format numbers resulting from 'math' formulas in WORD tabl

Hi mkraft,

You didn't need to navigate a tutorial - all you needed to do was to use Word's Help file. The tutorial I referred you to is aimed
at those who need to go well beyond the basics.

--
Cheers
macropod
[MVP - Microsoft Word]


"mkraft" wrote in message ...
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.


  #13   Report Post  
Posted to microsoft.public.word.tables
macropod[_2_] macropod[_2_] is offline
external usenet poster
 
Posts: 2,059
Default How format numbers resulting from 'math' formulas in WORD tabl

Hi mkraft,

The '\#' tells Word what type of formatting switch it is dealing with. What follows after the space is the switch format.

--
Cheers
macropod
[MVP - Microsoft Word]


"mkraft" wrote in message ...
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?

  #14   Report Post  
Posted to microsoft.public.word.tables
Doug Robbins - Word MVP Doug Robbins - Word MVP is offline
external usenet poster
 
Posts: 8,832
Default How format numbers resulting from 'math' formulas in WORD tabl

Have you tried the "Number format:" drop down in the Formula dialog?

--
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

"mkraft" wrote in message
...
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.



  #15   Report Post  
Posted to microsoft.public.word.tables
Doug Robbins - Word MVP Doug Robbins - Word MVP is offline
external usenet poster
 
Posts: 8,832
Default How format numbers resulting from 'math' formulas in WORD tabl

All you had to do was use the "Number format:" dropdown on the Formula
dialog.

--
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

"mkraft" wrote in message
...
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.





  #16   Report Post  
Posted to microsoft.public.word.tables
mkraft mkraft is offline
external usenet poster
 
Posts: 50
Default How format numbers resulting from 'math' formulas in WORD tabl

All you had to do was use the "Number format:" dropdown on the Formula
dialog.


So, the answer turns out to be a simple one.

Perhaps I didn't word my original inquiry clearly enough, as I don't
understand why it took so many replies (and more complex remedies, e.g.
'picture switches') to get to this simple solution.

I had looked for (and not found) a 'number format' option in the dropdown
menus, not having noticed it in the 'formula' dialog box. (Logically, a
'number format' needn't be tied to 'formulas' only -- i.e., it could apply to
all numeric entries.)

Thanks.
  #17   Report Post  
Posted to microsoft.public.word.tables
mkraft mkraft is offline
external usenet poster
 
Posts: 50
Default How format numbers resulting from 'math' formulas in WORD tabl

You didn't need to navigate a tutorial - all you needed to do was to use
Word's Help file.

Is the Help file (I assume you're referring to the Help that comes with
Word) available at Microsoft's website?

I don't have access to the 'internal' help file because currently I only use
Word (& a PC) at a public library, which for some reason doesn't provide the
'Help' that comes with program.

If it's duplicated somewhere at microsoft.com I would definitely consult it
in the future before posting here.

Thanks.
  #18   Report Post  
Posted to microsoft.public.word.tables
macropod[_2_] macropod[_2_] is offline
external usenet poster
 
Posts: 2,059
Default How format numbers resulting from 'math' formulas in WORD tabl

Hi mkraft,

Yes, I was referring to the Help file that can be accessed via 'Help' on Word's menu.

If the installation you're working with lacks that, you can access an on-line resource, for all versions of MS Office from Office
2000 onwards, via:
http://office.microsoft.com/en-us/he...CL100605171033

For fields, you can access the help via:
http://office.microsoft.com/en-us/wo...992711033.aspx
and the page for formatting fields is:
http://office.microsoft.com/en-us/wo...004261033.aspx
These are for Word 2007, but they're essentially the same as for previous versions.

--
Cheers
macropod
[MVP - Microsoft Word]


"mkraft" wrote in message ...
You didn't need to navigate a tutorial - all you needed to do was to use

Word's Help file.

Is the Help file (I assume you're referring to the Help that comes with
Word) available at Microsoft's website?

I don't have access to the 'internal' help file because currently I only use
Word (& a PC) at a public library, which for some reason doesn't provide the
'Help' that comes with program.

If it's duplicated somewhere at microsoft.com I would definitely consult it
in the future before posting here.

Thanks.


  #19   Report Post  
Posted to microsoft.public.word.tables
mkraft mkraft is offline
external usenet poster
 
Posts: 50
Default How format numbers resulting from 'math' formulas in WORD tabl

Yes, I was referring to the Help file that can be accessed via 'Help' on
Word's menu.

If the installation you're working with lacks that, you can access an on-line resource, for all
versions of MS Office from Office 2000 onwards, via:
http://office.microsoft.com/en-us/he...CL100605171033


Thanks a lot.
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
How do you format the numbers in a Word 2007 tables cells? Bob Arnett Tables 2 September 18th 08 04:56 PM
Using formulas in Word 2007 tables Aubin Tables 1 May 4th 07 04:33 AM
How to format negative numbers in Word tables Warrain Tables 9 March 17th 06 05:41 PM
Word tables: how do you format numbers? Steel Tables 10 April 5th 05 06:16 PM
Formulas in Word Tables Dave New Users 5 April 2nd 05 08:53 PM


All times are GMT +1. The time now is 10:25 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"