Reply
 
Thread Tools Display Modes
  #1   Report Post  
Posted to microsoft.public.word.docmanagement
Craig
 
Posts: n/a
Default Justifying negitive numbers in a column

I enter financial numbers in a column that are right justified. When I have
a negitive number (a number with (brackets) around it) I need for it to
allow the bracket on the right side of the number to penetrate the right
justification by one space so the actual numbers/digits will line up it the
column with the positive numbers. Any thoughts?

Thanks...Craig


  #2   Report Post  
Posted to microsoft.public.word.docmanagement
Richard O. Neville
 
Posts: n/a
Default Justifying negitive numbers in a column

Create the numbers part of your work in Excel, using the "Accounting"
format, which does what you describe. You can then paste it into Word, with
or without a link.

"Craig" wrote in message
. ..
I enter financial numbers in a column that are right justified. When I have
a negitive number (a number with (brackets) around it) I need for it to
allow the bracket on the right side of the number to penetrate the right
justification by one space so the actual numbers/digits will line up it the
column with the positive numbers. Any thoughts?

Thanks...Craig



  #3   Report Post  
Posted to microsoft.public.word.docmanagement
Suzanne S. Barnhill
 
Posts: n/a
Default Justifying negitive numbers in a column

Use a decimal tab stop; see
http://word.mvps.org/FAQs/Formatting/SettingTabs.htm. This aligns numbers on
the first non-numeric character (aside from the thousands separator)
following the numbers, which can be a closing parenthesis, an asterisk, etc.

--
Suzanne S. Barnhill
Microsoft MVP (Word)
Words into Type
Fairhope, Alabama USA
Word MVP FAQ site: http://word.mvps.org
Email cannot be acknowledged; please post all follow-ups to the newsgroup so
all may benefit.

"Craig" wrote in message
. ..
I enter financial numbers in a column that are right justified. When I

have
a negitive number (a number with (brackets) around it) I need for it to
allow the bracket on the right side of the number to penetrate the right
justification by one space so the actual numbers/digits will line up it

the
column with the positive numbers. Any thoughts?

Thanks...Craig



Reply
Thread Tools
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
On 2 column page layout can I put page numbers on each column p00ts Microsoft Word Help 1 August 1st 05 05:05 PM
How do I calculate page numbers ina 2 column document Liz S Page Layout 2 February 10th 05 12:49 PM
How do I insert a column of dash numbers in a table? paste dashed part no's Tables 1 January 13th 05 04:16 PM
Dragging table column resets Sedonakids Tables 0 January 12th 05 01:11 AM
change numbers in a column and continue number's in seq onto each. nhtpclerk Tables 1 December 10th 04 08:47 PM


All times are GMT +1. The time now is 11:14 PM.

Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 Microsoft Office Word Forum - WordBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Word"