Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Dollar format alignment
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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Dollar format alignment
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. "Paul" wrote: 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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Format Chart Title Alignment Vertical doesn't work | Charts and Charting in Excel | |||
Dollar sign alignment - Accounting vs Currency style | Excel Discussion (Misc queries) | |||
Format cells alignment defaults | Setting up and Configuration of Excel | |||
FORMAT CELLS ALIGNMENT | Excel Discussion (Misc queries) | |||
Make Alignment options under format cells available as shortcut | Excel Discussion (Misc queries) |