Dollar format alignment

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.
 
G

Guest

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

Format .txt file contents to numeric format will not work - help! 3
Is there a preferred protocol for alignment of numbers in a colum 3
Displaying results in dollars 3
Dollar sign alignment - Accounting vs Currency style 3
Align dollar symbol, align currency symbol... 1
Conditional Formatting to Change Cell Alignment? 3
Maintain Format of Pivot Table 1
Why are there inconsistencies in the display of zeroes in account. 5

Top