98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View ReviewsForum home » Delegate support and help forum » Microsoft Word Training and help » Word 2007
Word 2007
Resolved · High Priority · Version 2007
Helen has attended:
PowerPoint Intermediate Advanced course
Word Advanced course
Word 2007
How do I get brackets to align when I am working in a table with both positive and negative text. I have explained this to Simon (my trainer for today) - so hopefully he will be able to explain my queory in more detail.
RE: Word 2007
Hi Helen
Thanks for your question and welcome to the forum.
Am I correct in assuming that the negative figures contain extra characters, e.g. a negative amount would be displayed as (432) or -432 and you want any positive amounts to line up so that the last digits in each number line up with each other? How are your negative numbers displayed?
Also are you importing the data in from an Excel spreadsheet, or working with the data directly in Word?
thanks
Amanda
RE: Word 2007
We display our figures as (123123) and 12341234 and I need the numbers to line up not the brackets. It use to be a case of selecting 'align brackets' but I'm not sure how to find it now.
I am just working with the data directly in Word.
Thanks a lot
Helen
RE: Word 2007
Hi Helen
Was the 'align brackets' that you refer to available in the version of Word you used to use before 2007? If so where did it used to be located in the version of Word you used to use?
thanks
Amanda
RE: Word 2007
It was just in the pull down list where you change the header styles in a large document.
Thanks
Helen
RE: Word 2007
Hi Helen
I'm not sure that this is a standard style that comes with Word by default...maybe someone at your office created the style themselves? I will have a look into this a bit further and see if I can come up with a solution.
Kind regards
Amanda
RE: Word 2007
Hi Helen
Please have a look at the attached and let me know whether this is the sort of thing you are after (roughly).
thanks
Amanda
Attached files...
RE: Word 2007
Yes, exactly what I was looking for. How do you do it?
Thanks
Helen
RE: Word 2007
OK, I'm glad that is what you are after.
First you need to insert the table as an Excel spreadsheet rather than creating a normal table in Word.
To do this: Insert ribbon, click the dropdown arrow associated with the Object button, select Object, New and Excel Worksheet. Click OK.
You will now have a blank table that is in fact an Excel worksheet.
Select the column that you are going to put the figures in (e.g. if the figures are going in column B, click on the letter B at the top of the column.
Go to Home ribbon, and inside the group of Number buttons click the small arrow in the bottom right corner. This gets you into the Format Cells dialogue box.
On the Number tab, select Custom from the left hand side.
The word General will appear in the box under the word Type.
Select and delete the word General.
Type in the following: # ;(#)
Note there is a blank space between the first # and the ;
This is what makes the figures line up with each other.
Click OK.
Test by typing some figures into the column.
I hope this helps.
Amanda
Fri 20 Feb 2009: Automatically marked as resolved.
Training information:
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Word tip:Align Shapes in Your Word Document Using GridlinesWhen drawing shapes in Microsoft Word, in can be useful to turn on the drawing grid to make it easier to align various shapes with each other. To bring up gridlines on your document: |