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 do I line up commas if I am using a decimal tab.



 
 
Thread Tools Display Modes
  #1  
Old April 26th, 2004, 04:19 PM
Turmoil
external usenet poster
 
Posts: n/a
Default 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  
Old April 28th, 2004, 05:50 AM
Doug Robbins - Word MVP
external usenet poster
 
Posts: n/a
Default 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  
Old April 29th, 2004, 12:17 AM
Turmoil
external usenet poster
 
Posts: n/a
Default 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  
Old April 29th, 2004, 12:17 AM
Turmoil
external usenet poster
 
Posts: n/a
Default 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  
Old April 29th, 2004, 09:25 AM
Doug Robbins - Word MVP
external usenet poster
 
Posts: n/a
Default 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  
Old April 30th, 2004, 04:50 PM
Turmoil
external usenet poster
 
Posts: n/a
Default 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  
Old April 30th, 2004, 10:21 PM
EmileeSuzanne
external usenet poster
 
Posts: n/a
Default 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  
Old May 2nd, 2004, 03:49 PM
Turmoil
external usenet poster
 
Posts: n/a
Default 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  
Old May 3rd, 2004, 12:48 AM
Suzanne S. Barnhill
external usenet poster
 
Posts: n/a
Default 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  
Old May 3rd, 2004, 09:14 AM
Doug Robbins - Word MVP
external usenet poster
 
Posts: n/a
Default 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

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 04:24 PM.


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