word

Forum home » Delegate support and help forum » Microsoft Word Training and help » Word 2007

Word 2007

resolvedResolved · 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...

aligning numbers.doc

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 courses

 

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
What does 'Resolved' mean?

Any suggestions, questions or comments? Please post in the Improve the forum thread.


 

Word tip:

Align Shapes in Your Word Document Using Gridlines

When 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:

1. Check to see if the Drawing toolbar is showing on your screen - you can check by going to View - Toolbars and see if Drawing is ticked or not. If it is not ticked, then click on the word 'Drawing' to get the toolbar showing on your screen.

2. On the Drawing toolbar, click Draw on the left hand side.

3. Select Grid.

4. Select the Display gridlines on screen check box.

View all Word hints and tips


Server loaded in 0.08 secs.