Dollar sign left justified - data right justified - large space

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

Guest

I have this problem with data in a wide cell. Dollar sign is left justified,
data is right justified with a large annoying space between
 
You have the formatting set to Accounting. If you want to $ to be next to the
numbers, change the formatting to Currency.
 
Change your number format from Accounting to Currency.

Alternatively, to keep the other Accounting format elements, use
Format/Cells/Number/Custom

_($#,##0.00_);_($(#,##0.00);_($"-"??_);_(@_)
 
Thanks - wasted 30 mins looking for the solution myself - you saved me lots
of time.
 
You must log in or register to reply here.

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

merge cells without losing data OR format 1
How do I remove leading spaces the column is left justified 3
How do I autofill spaces in right justified fields? 1
Importing a space-delimited txt. file right-justified into Excel 2
Undeletable mark--amazing properties 3
Centering text in right-side header block 2
Justifying text across a range of cells Excel 2007? 5
Justify paragraph but center last line 2

Back
Top