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. |
|
|
|
Thread Tools | Display Modes |
#11
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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. |
|
Thread Tools | |
Display Modes | |
|
|