Every now and then I get a workbook from a client with numbers in Accounting format. If all the numbers are the same length, the currency symbols line up nicely. However, if the numbers are different lengths, some of the symbols are a bit off.

For example, in the screen shot below, the $ sign in cell B4 is a bit to the right of the symbol in B5. It's not much, but it looks sloppy, and some fonts show the effect more obviously than others. I added the blue line to make it easier to see the variations in column B.

Trying to Fix It

I've spent way too much time trying to fix the problem, with custom formatting, different fonts, and yelling. Even fist shaking didn't help -- very odd! So, I learned to live with the problem, and tried to convince the client to use Currency

Continue reading Trouble Aligning Excel Currency Symbols