word有符号时对齐_对齐Excel货币符号时遇到问题-CSDN博客

word有符号时对齐

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, we have trouble aligning Excel currency symbols.

我时不时从客户那里得到一份工作簿，上面有会计格式的数字。如果所有数字的长度相同，则货币符号会很好地对齐。但是，如果数字的长度不同，则在对齐Excel货币符号时会遇到麻烦。

货币符号不对齐 (Currency Symbols Do Not Line Up)

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.

例如，在下面的屏幕快照中，单元格B4中的$符号在B5中的符号右边。它虽然不多，但看起来草率，并且某些字体显示的效果比其他字体更明显。我添加了蓝线，以便更轻松地查看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 format instead. The dollar signs aren't supposed to line up in that format, so it's much less stressful.

因此，我学会了忍受这个问题，并试图说服客户使用货币格式。美元符号不应该以这种格式排列，因此压力较小。

寻找解决方案 (Finding the Solution)

Finally, this weekend, after another attempt at lining up the dollar signs, I found the solution to the wobbly Accounting symbols. I checked the horizontal alignment for the cells, and discovered that my client had formatted them as Right aligned.

终于，这个周末，在再次尝试排列美元符号之后，我找到了摇摆不定的“会计”符号的解决方案。我检查了单元格的水平对齐方式，发现我的客户已将其格式化为“右对齐”。

I clicked the button at the bottom right of the Alignment group on the Ribbon's Home tab, to open the Format Cells dialog box.

我单击了功能区“主页”选项卡上“对齐”组右下角的按钮，以打开“设置单元格格式”对话框。

Then, on the Alignment tab, I changed the Horizontal alignment to General, and clicked OK.

然后，在“路线”选项卡上，将“水平路线”更改为“常规”，然后单击“确定”。

问题解决了 (Problem Solved)

Miraculously, all the dollar signs lined up, without a single wobble, for the different font and sizes.

奇迹般地，所有的美元符号都排成一行，没有一个摆动，表示不同的字体和大小。

I'm not sure why the right alignment had been applied earlier, because numbers would automatically align to the right. Anyway, the alignment is the first thing I'll check, the next time I have trouble with wandering currency symbols.

我不确定为什么早先应用了正确的对齐方式，因为数字会自动对齐到右侧。无论如何，对齐是我要检查的第一件事，下次我在徘徊货币符号时遇到麻烦。

And if you already knew how to fix this problem, you should have told me years ago! ______________

如果您已经知道如何解决此问题，那么几年前您应该告诉我！ ______________