Decimal Tabs & Headings
Alex
am using a decimal tab to align the (negative) numbers correctly, but at the
top of the column I want a pound Ł sign to appear over the second digit
after the decimal point (as is the standard in many accounts programs). How
is this possible, as if I simply type in Ł it appear to the left of the
decimal point. Currently the only way I can do it is to type .0Ł and make
the .0 hidden which is pretty horrible.
Thanks for any help, Alex
Terry Farrell
surprising, many characters can act as the decimal and not just the default
. that we use (in fact, any punctuation key except the default thousands
separator as defined in the Windows, Control Panel, Regional settings). The
£ itself can act as the decimal and will align to the decimal tab. So select
the top 'heading row' and move the decimal tab so that it aligns the £ sign
directly above the required column (tip: hold the Alt key to override snap
to grid while you move the tab along the ruler).
--
Terry Farrell - MSMVP Word
Please keep replies in the Newsgroup.
This enables everyone to share the problem
and other experts to bring their expertise.
________________________________________________________________
For direct access to all Microsoft newsgroups:
news://msnews.microsoft.com/
Sorry, but emails cannot be acknowledged.
"Alex" <al...@virgin.net> wrote in message
news:uDyXoJVe$GA.276@cppssbbsa05...
| Hi, I have a table with a column of amount formatted to 2 decimal places.
I
| am using a decimal tab to align the (negative) numbers correctly, but at
the
| top of the column I want a pound £ sign to appear over the second digit
| after the decimal point (as is the standard in many accounts programs).
How
| is this possible, as if I simply type in £ it appear to the left of the
| decimal point. Currently the only way I can do it is to type .0£ and make
Suzanne S. Barnhill
center alignment, so just set a tab (center tab might be easiest) where you
want the pound sign to be and enter a tab character (Ctrl+Tab) to place it
there. Or right-align the heading and drag the right margin marker till the
pound sign is aligned correctly.
--
Suzanne S. Barnhill
Microsoft Word MVP
Words into Type
Fairhope, AL USA
Terry Farrell <terryf...@msn.com> wrote in message
news:#Zq5rUWe$GA....@cppssbbsa02.microsoft.com...
Alex
over the third zero in 0.00. I really wanted to avoid having to insert tabs
other than the default decimal one, as I have a macro that formats a column
with a decimal tab.
Alex
"Suzanne S. Barnhill" <sbar...@zebra.net> wrote in message
news:#XWbf8We$GA.275@cppssbbsa04...
Dave Rado
Make your macro format the top cell in the column differently from the rest
of the column - in the top cell create a left aligned tab.
So in your macro, format the column first, then in the top cell, use
Selection.ParagraphFormat.TabStops.ClearAll and then set the left-aligned
tabstop
Regards
Dave
Alex <al...@virgin.net> wrote in message news:#zbFuHGf$GA.166@cppssbbsa04...
Terry Farrell
did you not read my reply of 17th which makes it EASY?
Terry
Suzanne S. Barnhill
zero in 0.00, but he wants it to align over the LAST zero. If all the
figures have the same number of decimal places, it would work just as well
to right-align everything (using a right paragraph indent if necessary to
clear the edge of the cell).
--
Suzanne S. Barnhill
Microsoft Word MVP
Words into Type
Fairhope, AL USA
Terry Farrell <terryf...@msn.com> wrote in message
news:OotaCOHf$GA....@cppssbbsa02.microsoft.com...
Alex
row.
"Dave Rado" <dave...@contactbox.co.uk> wrote in message
news:u8BESdGf$GA.253@cppssbbsa04...
> Hi Alex
>
> Make your macro format the top cell in the column differently from the
rest
> of the column - in the top cell create a left aligned tab.
>
> So in your macro, format the column first, then in the top cell, use
> Selection.ParagraphFormat.TabStops.ClearAll and then set the left-aligned
> tabstop
>
> Regards
>
> Dave
>
Alex
right of an amount, therefore if you right align the £ it goes to this
position. I could create a separate style for table column headings (£
signs) with a right indent but it just seems so long winded.
Alex
"Suzanne S. Barnhill" <sbar...@zebra.net> wrote in message
news:e7gUPqHf$GA....@cppssbbsa02.microsoft.com...
> It would make it easy if he wanted the pound sign to align over the FIRST
> zero in 0.00, but he wants it to align over the LAST zero. If all the
> figures have the same number of decimal places, it would work just as well
> to right-align everything (using a right paragraph indent if necessary to
> clear the edge of the cell).
>
> --
> Suzanne S. Barnhill
> Microsoft Word MVP
> Words into Type
> Fairhope, AL USA
>
> Terry Farrell <terryf...@msn.com> wrote in message
> news:OotaCOHf$GA....@cppssbbsa02.microsoft.com...
> > Alex,
> >
> > did you not read my reply of 17th which makes it EASY?
> >
> > Terry
> >
Peter Boulding
<sbar...@zebra.net> wrote:
>It would make it easy if he wanted the pound sign to align over the FIRST
>zero in 0.00, but he wants it to align over the LAST zero. If all the
>figures have the same number of decimal places, it would work just as well
>to right-align everything (using a right paragraph indent if necessary to
>clear the edge of the cell).
Unless the negative figures are indicated either by a trailing
minus sign or by brackets.
I think Alex can overcome this by setting his macro to use the
same decimal tab on all rows, but to insert "0.0£" (for those not
using a UK character set, that's zero, period, zero, pound sign)
in the top row - with the font colour of the zeros and decimal
point formatted to white.
--
Regards
Peter Boulding
p...@UNSPAMpboulding.co.uk (to e-mail, remove "UNSPAM")
[Please reply to the newsgroup. E-mail queries may be ignored.]
Alex
"Peter Boulding" <p...@UNSPAMpboulding.co.uk> wrote in message
news:0mo2bscghift21onv...@4ax.com...
Peter Boulding
wrote:
>Yes, completely correct, but I don't want the 0.0 which I must hide.
Which is why I suggested formatting the font colour of the "0.0"
to white. Is that not an acceptable workaround?
Alex
using Ami Pro last year - which doesn't have the problem, albeit of course I
appreciate Word is a major step up from Ami Pro, which kind of makes it all
the more amazing.news:to95bskh0r62aj20f...@4ax.com...
Peter Boulding
wrote:
>Yes, white / hidden, but try telling that to 2000 users who were happily
>using Ami Pro last year - which doesn't have the problem, albeit of course I
>appreciate Word is a major step up from Ami Pro, which kind of makes it all
>the more amazing.
<absence of proper sympathy>
I'm finding hard to get upset about this problem. Ami Pro was
bound to be better at some things; if this is the kind of grief
you're getting from 2000 inevitably disgruntled users who've been
forced to switch WP systems, you're doing well.
You can set up a shortcut key (attached to either autotext or a
macro) to paste in the preformatted string. Ctrl+UKP
(Shift+Ctrl+3) is currently unassigned.
John McGhie [MVP - Word]
Begone you horrid person!!! We do NOT format things to white in
professional documentation any longer!! Go and wash your mouth out at
once!!
Seriously: It's an effective technique if you absolutely have to use it,
but it creates horrendous maintenance problems in the corporate workplace,
because people do not realise that the document relies on hidden entities
and they trash them, bringing the whole document unstuck and wasting hours.
In his case, he is just trying to save himself a line of code that he is
going to have to use anyway. Not only does he have to use different tabs in
his header row, he also has to set the Header property, so he has to
identify that row and get into it anyway, while he is there, he might as
well apply the tab.
In his case, he needs a decimal tab on the figures and a simple right tab on
the Ł sign. However, since he has formatted the column to two decimals, and
numbers are often the same width, he could probably get away with using a
right tab for both. The result will be so close the eye will not detect the
difference.
White text indeed.... Shame, shame, shame...!!!
Cheers.
In microsoft.public.word.tables on Tue, 22 Feb 2000 15:14:07 +0000, Peter
Boulding <p...@UNSPAMpboulding.co.uk> wrote:
> On Tue, 22 Feb 2000 11:23:37 -0000, "Alex" <al...@virgin.net>
> wrote:
>
> >Yes, completely correct, but I don't want the 0.0 which I must hide.
>
> Which is why I suggested formatting the font colour of the "0.0"
> to white. Is that not an acceptable workaround?
Please post follow-up questions to the newsgroup so that all may follow the thread.
John McGhie <jo...@mcghie-information.com.au>
Consultant Technical Writer
Microsoft MVP (Word)
Sydney, Australia (GMT +10 hrs) +61 (04) 1209 1410
Peter Boulding
<jo...@mcghie-information.com.au> wrote:
>Peter!!!
>
>Begone you horrid person!!! We do NOT format things to white in
>professional documentation any longer!! Go and wash your mouth out at
>once!!
>
>Seriously: It's an effective technique if you absolutely have to use it,
>but it creates horrendous maintenance problems in the corporate workplace,
>because people do not realise that the document relies on hidden entities
>and they trash them, bringing the whole document unstuck and wasting hours.
>
>In his case, he is just trying to save himself a line of code that he is
>going to have to use anyway. Not only does he have to use different tabs in
>his header row, he also has to set the Header property, so he has to
>identify that row and get into it anyway, while he is there, he might as
>well apply the tab.
>
>In his case, he needs a decimal tab on the figures and a simple right tab on
>the Ł sign. However, since he has formatted the column to two decimals, and
>numbers are often the same width, he could probably get away with using a
>right tab for both. The result will be so close the eye will not detect the
>difference.
>
>White text indeed.... Shame, shame, shame...!!!
<unpeels self from floor, dusts self down, straightens hair and
clothing>
Couldn't agree more, John - in principle. But Alex is already
experiencing that corporate nightmare: he's afraid that 2000
disgruntled ex-Ami Pro users are going to tear him to shreds if
they can't have that pounds sign over the pennies column (Why,
for Heaven's sake? - it's got to be about as silly a place to put
it as any other...) And styles/formatting/layout that "must be
like this because that's the way we always done it" are the
surest road to trouble, come what may.
Plus: unless I've misunderstood his earlier comment,
>Thanks Dave, but I cannot guarantee that the pound sign will be in the first
>row
he *can't* include this pounds sign in his macro; the 2000 have
to be able to insert it where and when they want to. So either
he's prepared to put two tabs in that column (I would, but he
doesn't want to) or he's got to use a kludgy workaround.
>Cheers.
Mud in your eye.
John McGhie [MVP - Word]
In microsoft.public.word.tables on Sat, 26 Feb 2000 19:07:54 +0000, Peter
Boulding <p...@UNSPAMpboulding.co.uk> wrote:
> <unpeels self from floor, dusts self down, straightens hair and
> clothing>
Ooops... Was I a little over the top? {blush}
> Couldn't agree more, John - in principle. But Alex is already
> experiencing that corporate nightmare: he's afraid that 2000
> disgruntled ex-Ami Pro users are going to tear him to shreds if
> they can't have that pounds sign over the pennies column (Why,
> for Heaven's sake? - it's got to be about as silly a place to put
> it as any other...) And styles/formatting/layout that "must be
> like this because that's the way we always done it" are the
> surest road to trouble, come what may.
God, haven't we all been there :-)
I was more concerned that the 2000 are going to come *back* next week
because their documents have "gone funny" since they have by now forgotton
that some of their table columns contain invisible text.
Maybe Dave's on a *short* contract and figures he can get out of there
before it blows up? :-)
Cheers.
Dave Rado
| before it blows up? :-)
Hi John - I think you meant Alex!
Regards
Dave
Peter Boulding
Alex has gone awful quiet... :)
Alex
use Excel tables instead, as that gets around the problem.news:bt92cs4gae5scpi4h...@4ax.com...