Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default Formating Cells In 2003

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
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 35,218
Default Formating Cells In 2003

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.

Limey wrote:

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


--

Dave Peterson
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
2007 to 2003 Formating issues Wayne Excel Discussion (Misc queries) 1 February 4th 10 03:51 PM
In MS Excel 2003, need to do conditional formating on HLOOKUP Shikha Excel Worksheet Functions 3 February 26th 09 11:42 PM
Conditional Formating/Excel 2007 to 2003 Christopher Hogan Excel Discussion (Misc queries) 1 January 22nd 09 04:30 AM
Yet another conditional formating question (Excel 2003) REJesser Excel Discussion (Misc queries) 8 May 14th 08 05:02 PM
conditional formating cells i Excel based on other cells values Elias Petursson Excel Worksheet Functions 3 May 23rd 06 06:45 PM


All times are GMT +1. The time now is 12:43 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"