Discussion:
decimal alignment
(too old to reply)
Tom Gumpel
2013-01-28 12:57:55 UTC
Permalink
I am trying to decimal align in a table, where many numbers do not have a leading 0 (i.e., .25, .50) and they need to be aligned with larger numbers such as 1.25, 2.50, etc.

The numbers are not aligning, but will if I add a leading 0 (which I cannot do for stylistic reasons).

Any help?
Lisa Wilke-Thissen
2013-01-28 14:58:51 UTC
Permalink
Hi,
Post by Tom Gumpel
I am trying to decimal align in a table, where many numbers do not
have a leading 0 (i.e., .25, .50) and they need to be aligned with
larger numbers such as 1.25, 2.50, etc.
The numbers are not aligning, but will if I add a leading 0 (which I
cannot do for stylistic reasons).
no problem here. Did you set a decimal tabstop position within the
column?

--
Cheers
Lisa [MS MVP Word]
Tom Gumpel
2013-01-28 15:23:56 UTC
Permalink
I may have figured it out, after obsessing on it. I am in Europe and found that on my laptop (set up for the US), everything was OK. However, on my office computer (set up for Finnish Swedish),the decimal point was set as a "," -- I changed the setting in the control panel and it seems to be OK.

Makes sense.
Post by Lisa Wilke-Thissen
Hi,
Post by Tom Gumpel
I am trying to decimal align in a table, where many numbers do not
have a leading 0 (i.e., .25, .50) and they need to be aligned with
larger numbers such as 1.25, 2.50, etc.
The numbers are not aligning, but will if I add a leading 0 (which I
cannot do for stylistic reasons).
no problem here. Did you set a decimal tabstop position within the
column?
--
Cheers
Lisa [MS MVP Word]
Stefan Blom
2013-01-29 00:50:12 UTC
Permalink
Actually, any non-numeric character should "respond" to the decimal tab, so
I doubt that regional settings are the issue here.
--
Stefan Blom
Microsoft Word MVP
Post by Tom Gumpel
I may have figured it out, after obsessing on it. I am in Europe and found
that on my laptop (set up for the US), everything was OK. However, on my
office computer (set up for Finnish Swedish),the decimal point was set as
a "," -- I changed the setting in the control panel and it seems to be OK.
Makes sense.
Post by Lisa Wilke-Thissen
Hi,
Post by Tom Gumpel
I am trying to decimal align in a table, where many numbers do not
have a leading 0 (i.e., .25, .50) and they need to be aligned with
larger numbers such as 1.25, 2.50, etc.
The numbers are not aligning, but will if I add a leading 0 (which I
cannot do for stylistic reasons).
no problem here. Did you set a decimal tabstop position within the
column?
--
Cheers
Lisa [MS MVP Word]
Suzanne S. Barnhill
2013-01-29 04:10:40 UTC
Permalink
Not quite true. When a decimal tab stop is set in a table, the column aligns
on the tab stop without the need for a tab character. Text aligns on the
decimal point or, failing that, on the first non-numeric character in the
cell EXCEPT for the thousands separator. In much of the world, where a
period is used for the decimal point and the comma as the thousands
separator, the text will align on the period, but if the comma is used as
the decimal point and the period as the thousands separator, it is just the
opposite. For more, see
http://WordFAQs.mvps.org/NumberAlignment.htm (Word 2003 and earlier)
http://WordFAQs.mvps.org/NumberAlignment2007.htm (Word 2007 and above)

"Stefan Blom" wrote in message news:ke76bu$2n9$***@dont-email.me...

Actually, any non-numeric character should "respond" to the decimal tab, so
I doubt that regional settings are the issue here.
--
Stefan Blom
Microsoft Word MVP
Post by Tom Gumpel
I may have figured it out, after obsessing on it. I am in Europe and found
that on my laptop (set up for the US), everything was OK. However, on my
office computer (set up for Finnish Swedish),the decimal point was set as
a "," -- I changed the setting in the control panel and it seems to be OK.
Makes sense.
Post by Lisa Wilke-Thissen
Hi,
Post by Tom Gumpel
I am trying to decimal align in a table, where many numbers do not
have a leading 0 (i.e., .25, .50) and they need to be aligned with
larger numbers such as 1.25, 2.50, etc.
The numbers are not aligning, but will if I add a leading 0 (which I
cannot do for stylistic reasons).
no problem here. Did you set a decimal tabstop position within the
column?
--
Cheers
Lisa [MS MVP Word]
Stefan Blom
2013-01-29 15:27:26 UTC
Permalink
Thanks for the clarification!
--
Stefan Blom
Microsoft Word MVP
Post by Suzanne S. Barnhill
Not quite true. When a decimal tab stop is set in a table, the column
aligns on the tab stop without the need for a tab character. Text aligns
on the decimal point or, failing that, on the first non-numeric character
in the cell EXCEPT for the thousands separator. In much of the world,
where a period is used for the decimal point and the comma as the
thousands separator, the text will align on the period, but if the comma
is used as the decimal point and the period as the thousands separator, it
is just the opposite. For more, see
http://WordFAQs.mvps.org/NumberAlignment.htm (Word 2003 and earlier)
http://WordFAQs.mvps.org/NumberAlignment2007.htm (Word 2007 and above)
Actually, any non-numeric character should "respond" to the decimal tab, so
I doubt that regional settings are the issue here.
--
Stefan Blom
Microsoft Word MVP
Post by Tom Gumpel
I may have figured it out, after obsessing on it. I am in Europe and
found that on my laptop (set up for the US), everything was OK. However,
on my office computer (set up for Finnish Swedish),the decimal point was
set as a "," -- I changed the setting in the control panel and it seems
to be OK.
Makes sense.
Post by Lisa Wilke-Thissen
Hi,
Post by Tom Gumpel
I am trying to decimal align in a table, where many numbers do not
have a leading 0 (i.e., .25, .50) and they need to be aligned with
larger numbers such as 1.25, 2.50, etc.
The numbers are not aligning, but will if I add a leading 0 (which I
cannot do for stylistic reasons).
no problem here. Did you set a decimal tabstop position within the
column?
--
Cheers
Lisa [MS MVP Word]
Loading...