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 |
#1
|
|||
|
|||
How do I line up commas if I am using a decimal tab.
I am using a decimal tab. I also want negative numbers to be in red font. ------------------------------------------------ ~~ Message posted from http://www.WordForums.com/ |
#2
|
|||
|
|||
How do I line up commas if I am using a decimal tab.
That's not the answer to the question.
If you want negative numbers in red, insert an Excel spreadsheet rather than use a Word table. -- Please post any further questions or followup to the newsgroups for the benefit of others who may be interested. Unsolicited questions forwarded directly to me will only be answered on a paid consulting basis. Hope this helps Doug Robbins - Word MVP "Turmoil" wrote in message ... I am using a decimal tab. I also want negative numbers to be in red font. ------------------------------------------------ ~~ Message posted from http://www.WordForums.com/ |
#3
|
|||
|
|||
How do I line up commas if I am using a decimal tab.
What do you mean by "decimal seperater"? ------------------------------------------------ ~~ Message posted from http://www.WordForums.com/ |
#4
|
|||
|
|||
How do I line up commas if I am using a decimal tab.
What do you mean by "decimal seperater"? ------------------------------------------------ ~~ Message posted from http://www.WordForums.com/ |
#5
|
|||
|
|||
How do I line up commas if I am using a decimal tab.
The way the decimals are separated in the Number Sample that appears on the
Regional Options tab of the Regional and Language Options item in the Windows Control Panel. In some countries a comma is used as a separator, in others its a period. But if you want negative numbers in Red, use and Excel spreadsheet in your document so that you can use Excel's cell number formatting capability. -- Please post any further questions or followup to the newsgroups for the benefit of others who may be interested. Unsolicited questions forwarded directly to me will only be answered on a paid consulting basis. Hope this helps Doug Robbins - Word MVP "Turmoil" wrote in message ... What do you mean by "decimal seperater"? ------------------------------------------------ ~~ Message posted from http://www.WordForums.com/ |
#6
|
|||
|
|||
How do I line up commas if I am using a decimal tab.
Sample: Number = 123,456,789.00 ------------------------------------------------ ~~ Message posted from http://www.WordForums.com/ |
#7
|
|||
|
|||
How do I line up commas if I am using a decimal tab.
Doug's reply makes a lot of sense . . . a decimal tab is made to line up the _decimal_, not the commas. Excel has the capability of "conditional formatting," with which you can make all negative numbers automatically turn red. You could then insert the spreadsheet directly into Word if need be. ------------------------------------------------ ~~ Message posted from http://www.WordForums.com/ |
#8
|
|||
|
|||
How do I line up commas if I am using a decimal tab.
That isn't accurate..I have a financial table created in Word that has the commas and decimals aligned. ------------------------------------------------ ~~ Message posted from http://www.WordForums.com/ |
#9
|
|||
|
|||
How do I line up commas if I am using a decimal tab.
It is true that you need Excel to apply the red format automatically to
negative numbers, but it is also true that a decimal tab will align numbers on the decimal point *whether or not it is present.* In other words, you can align numbers as various as these: $1,200.00 2.14159 30,000 (300.00) $500* All will align on the first nonnumeric character that is not a thousands separator (the comma in English usage). This means that you can use parentheses, note reference marks, and a variety of other text (including spaces) after the numbers, and the number will align on either the decimal point or the place where it would be if there were one. And note that parentheses are commonly used to indicate negative numbers in Word documents. -- Suzanne S. Barnhill Microsoft MVP (Word) Words into Type Fairhope, Alabama USA Word MVP FAQ site: http://www.word.mvps.org Email cannot be acknowledged; please post all follow-ups to the newsgroup so all may benefit. "EmileeSuzanne" wrote in message ... Doug's reply makes a lot of sense . . . a decimal tab is made to line up the _decimal_, not the commas. Excel has the capability of "conditional formatting," with which you can make all negative numbers automatically turn red. You could then insert the spreadsheet directly into Word if need be. ------------------------------------------------ ~~ Message posted from http://www.WordForums.com/ |
#10
|
|||
|
|||
How do I line up commas if I am using a decimal tab.
What isn't accurate?
If that stupid WordForums.Com thing would thread posts properly, (and if your response was to the relevant post which I am assuming it is), I would not have to ask that question. With proportional spaced fonts, the numbers all occupy the same space, so if you have the same number of digits between each set of commas and the between the last comma and the decimal point, if the number is aligned on a decimal tab, then the commas will be lined up. If you are mixing a number of Indian Rupees with Dollars then they won't line up because the number of digits between the last two commas is not the same. -- Please post any further questions or followup to the newsgroups for the benefit of others who may be interested. Unsolicited questions forwarded directly to me will only be answered on a paid consulting basis. Hope this helps Doug Robbins - Word MVP "Turmoil" wrote in message ... That isn't accurate..I have a financial table created in Word that has the commas and decimals aligned. ------------------------------------------------ ~~ Message posted from http://www.WordForums.com/ |
Thread Tools | |
Display Modes | |
|
|