Formating Cells In 2003

L

Limey

Hello,

I have a strange question and am looking for some help to answer this.

I have two machines, both running Office 2003 SP3. On one machine when I
format a cell to either Numbers or Currency I get the display to show
brackets () however on the other machine there are no Brackets shown. Both
Office versions are exactly the same, both machines are running XP SP3.

This is causing problems as on both machines worksheets need to be created
and when the one formats the cells they do not get the brackets which are
required.

Can anyone shed some light on this for me?

Cheers
 
D

Dave Peterson

If you want the ()'s to show up for negative numbers in the format|cells|number
tab, you'll have to change a windows setting.

Windows start button|control panel
regional and language options
regional options tab
click the customize button
currency tab
change the negative currency format to show ()'s.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

negative numbers 2
Brackets on one PC but not another in Excel 2003? 6
Default Negative Number format across versions 5
Excel cells randomly don't get updated 3
Excel cells randomly don't get updated unless each cell is updated 5
Replace html code - formula too long 1
Excel 2003 attachments open and show only empty cells when openedvia Outlook 2003? 1
Negative Numbers in Brackets - HELP! 21

Top