Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.tables
|
|||
|
|||
How do I specifiy the format of a series of numbers in a colmn?
I have a series of numbers in a column, resulting from horizontal
multiplications, and they vary in format: xxx.xx, xxxx.x, xxx, etc. How do I make the entire column show only integers (xxx), no cents? I can find nothing to format the numbers. |
#2
Posted to microsoft.public.word.tables
|
|||
|
|||
How do I specifiy the format of a series of numbers in a colmn?
If you are using a formula to perform the calculation, you can add a
formatting switch to the field. 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 "Ed" wrote in message ... I have a series of numbers in a column, resulting from horizontal multiplications, and they vary in format: xxx.xx, xxxx.x, xxx, etc. How do I make the entire column show only integers (xxx), no cents? I can find nothing to format the numbers. |
#3
Posted to microsoft.public.word.tables
|
|||
|
|||
How do I specifiy the format of a series of numbers in a colmn
Isn't there a way i can highlight the resulting column, and format all the
numbers in that column to be just integers, rather than dollars and cents, and not have to go through each formula and add the "switch" to each one? I recall that even in Lotus (certainly not the best word processor) and others I've used I could just format the entire batch of numbers with one formatting selection. Thank you. "Doug Robbins - Word MVP" wrote: If you are using a formula to perform the calculation, you can add a formatting switch to the field. 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 "Ed" wrote in message ... I have a series of numbers in a column, resulting from horizontal multiplications, and they vary in format: xxx.xx, xxxx.x, xxx, etc. How do I make the entire column show only integers (xxx), no cents? I can find nothing to format the numbers. |
#4
Posted to microsoft.public.word.tables
|
|||
|
|||
How do I specifiy the format of a series of numbers in a colmn
Unfortunately, there is no way to specify a numeric format for table
cells in Word. Fields are your only choice. Therefore, it might be easier to embed an Excel spreadsheet rather than performing calculations within Word tables. On the other hand, since you *are* calculating in Word, you are already using fields to which you could add formatting switches. -- Stefan Blom Microsoft Word MVP "Ed" wrote in message ... Isn't there a way i can highlight the resulting column, and format all the numbers in that column to be just integers, rather than dollars and cents, and not have to go through each formula and add the "switch" to each one? I recall that even in Lotus (certainly not the best word processor) and others I've used I could just format the entire batch of numbers with one formatting selection. Thank you. "Doug Robbins - Word MVP" wrote: If you are using a formula to perform the calculation, you can add a formatting switch to the field. 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 "Ed" wrote in message ... I have a series of numbers in a column, resulting from horizontal multiplications, and they vary in format: xxx.xx, xxxx.x, xxx, etc. How do I make the entire column show only integers (xxx), no cents? I can find nothing to format the numbers. |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Mail merge Labels Excel to Word - Need Help with format of numbers | Mailmerge | |||
How to format page numbers with blank in MS Word 2003? | Microsoft Word Help | |||
Format Numbers in Cells? | Tables | |||
How do you format numbers within a document? | New Users | |||
Stopping auto format for page numbers and locations. | Page Layout |