Custom Formatting

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am using the following custom format and the $ signs in the column are not lining up properly. The numbers are all positive but consist of a different number of digits. Was hoping you could offer a solution:

_($*#,##0_);_($*(#,##0);_($*"-"??_);_(@_)
 
One way:

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

though if the numbers are really all positive, then you only need

_($* #,##0_)



I'd recommend the dash be a en-dash for zero, rather than a hyphen...
 

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

Custom Number Format for text 8
Assign custom number format to the ribbon 0
Custom format to center 1
Customer number format 2
Custom Number formats adding months after numerals 2
custom formatting 2
Built-in Number Format "#,##0_);(#,##0)" 1
Alignment in Custom Number Formats 1

Back
Top