Dollar format alignment

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

Guest

Is it possible to have the dollar format $0.00 aligned to the left. The
program ignores my request for left alignment. I can do it with the TEXT
function, but I am hoping that there is a simpler option.
 
Yes. If it's formatted as an accounting cell, it'll send the dollar sign to
the left, and the numbers will be formated on the right. You don't like that,
right? I think what you want to do is have it all at the left, if I'm getting
you. Format the cells as currency and set it to left alignment. That does it.
 

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

Dollar sign alignment - Accounting vs Currency style 3
alignment in a validation list 3
Right align partial text in a text box 2
Secondary Axis - Alignment of Dollar Values 2
Left align '$' and right align numbers? 1
Format .txt file contents to numeric format will not work - help! 3
Align $ sign next to numbers 5
Format numbers so they align 2

Back
Top