In Excel 2000, "format cells accounting" got me brackets around negative
numbers. Excel 2003 gives me a negative sign. Is there any to change this?
I know I can get the format I want in custom, but this seems to require
formatting each cell.
In Excel 2000, "format cells accounting" got me brackets around negative
numbers. Excel 2003 gives me a negative sign. Is there any to change this?
I know I can get the format I want in custom, but this seems to require
formatting each cell.
Highlight all the desired cells. Right click and select Format Cells. From
the Number tab you can select the desired view.
"allan" wrote:
> In Excel 2000, "format cells accounting" got me brackets around negative
> numbers. Excel 2003 gives me a negative sign. Is there any to change this?
> I know I can get the format I want in custom, but this seems to require
> formatting each cell.
Allan
Just when using the Accounting format? When you Format>Cells>Number>Number do
you see an option for brackets?
If not..........
This is a function of your Regional Settings in Windows OS.
Start>Settings>Control Panel>Regional and Language Settings>Regional
Options>Customize>Currency>Negative Currency Format. Click on drop-down arrow
and select the ($1.1)
Apply and OK>Apply your way out.
You will have to close Excel then re-open to see effects.
If you already have the brackets format available you could go to
Format>Styles and select Accounting and modify to your liking.
Gord Dibben Excel MVP
On Sat, 12 Feb 2005 12:17:01 -0800, "allan" <[email protected]>
wrote:
>In Excel 2000, "format cells accounting" got me brackets around negative
>numbers. Excel 2003 gives me a negative sign. Is there any to change this?
>I know I can get the format I want in custom, but this seems to require
>formatting each cell.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks