Formula for a cell in Excel. Positioning the "(". l hade it - then I lost it!

You will not believe this.  I was logged into EE about to pose this question.  Just as I was about to copy the cell formula which appears below, I tried a couple of variations and found the write combination.  I logged out, closed the browser tab and GOT THE BLUE SCREEN OF DEATH!  (I didn't think that was possible in a 64-bit environment.)  Long story short - autosave was set to 10 minutes and my formula is gone....

The accounting formula set to no decimals and no $ sign displays a negative number as   (1,234)
I believe this is the formula
_(* #,##0_);_(* (#,##0);_(* "-"_);_(@_)
I want to display a negative number with the left parenthesis in the left-most position, like this...    (     1,234)
(I know, I am an accounting dinosaur.)
Any suggestions?
LVL 1
Bill GoldenExecutive Managing MemberAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Saurabh Singh TeotiaCommented:
Try this...It will do what you are looking for...

#,##0_);[Red](  #,##0)

Open in new window


And let's say you just want to show black only then...

#,##0_);(  #,##0)

Open in new window


Saurabh...
Bill GoldenExecutive Managing MemberAuthor Commented:
Sorry.  That just changed the number to be displayed in Red and added one space between the left parenthesis and the number.
Saurabh Singh TeotiaCommented:
Did you try the second one? It will keep the format as a blank only and will add space between the number and bracket..
Big Business Goals? Which KPIs Will Help You

The most successful MSPs rely on metrics – known as key performance indicators (KPIs) – for making informed decisions that help their businesses thrive, rather than just survive. This eBook provides an overview of the most important KPIs used by top MSPs.

Bill GoldenExecutive Managing MemberAuthor Commented:
Sorry, I did not initially see the second one.  But it does not work either.  The number of course does not display in red but the formula still only adds one space between the number and the left parenthesis.  

I am looking for the following format:

(123,456,789)
(  23,456,789)
(    3,456,789)
(       456,789)
(         56,789)
Saurabh Singh TeotiaCommented:
Use this...

#,##0_);(???,???,##0)

Open in new window


Saurabh...
Rob HensonFinance AnalystCommented:
Bit of playing, came up with:

* #,##0_);(* #,##0);(* "-"??_);_(@_)

EDITED:

#,##0_);(* #,##0);"-"??_);_(@_)

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Bill GoldenExecutive Managing MemberAuthor Commented:
Sorry Saurabh, your solution was column width dependent while Rob's accomplishes the task regardless of the width of the column.
Rory ArchibaldCommented:
You were really close with your original - it's:

_(* #,##0_);(* #,##0);_(* "-"_);_(@_)

rather than:
_(* #,##0_);_(* (#,##0);_(* "-"_);_(@_)
Rob HensonFinance AnalystCommented:
Thanks
Rory ArchibaldCommented:
It's just a question of whether you want to force positive numbers to leave a space for the opening parenthesis so that you never get a digit lined up with a parenthesis.
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Excel

From novice to tech pro — start learning today.