Excel Formatting Question

[CycloWizard]

Is there any way in Excel to align the decimals in a table and still display the negative sign, rather than putting () around negative numbers? I know the 'Accounting' number format will align the decimals, but the parentheses ruin everything!

Thanks!

 

[Thyme]

Currency doesn't work?

 

[BlueWeasel]

Sure, just use a personal formatting code instead of using the General or Accounting formats

See the codes here (specifically the question mark codes)

 

[CycloWizard]

Originally posted by: Thyme
Currency doesn't work?

That was my first thought too, but it doesn't do decimal alignment.

Originally posted by: BlueWeasel
Sure, just use a personal formatting code instead of using the General or Accounting formats

See the codes here (specifically the question mark codes)

Excellent, thank you sir! :beer:

Here's what I ended up using:
_(* ##0.00_);_(* -##0.00_);_(* ?.??_);_(@_)

Works like a charm. I think that link is a little outdated (using its codes didn't actually work), but the basic ideas are the same. The key is to figure out the order that the formats must be entered in, then modify one of the existing ones to do what you need. Thanks again!