currency symbol not aligned

[highpixel]

Hi, I am new to the forum and also not very savvy with Excel. This may be an easy question but I just don't know how to solve it. Any help is appreciated! I use Excel 2008 on mac.

1. I am using accounting format for the price column of my spreadsheet. I like how the figure is indented away from the currency symbol. Now all the figure is right aligned properly, but the currency symbol is not. It is positioned based on the number of digits in the figure, so all the currency symbols are not aligned but crooked vertically. I don't know how to attach a screenshot or excel file to the post, otherwise I would explain it better.... How can I make all currency symbols all aligned?

2. I have a merged cell with 4 paragraphs of text. When I save the document in pdf, the text became #######. Any tip to fix this? It looks just fine on excel but not on pdf.

Thanks so much!!!

 

[Dave Patton]

Hello and welcome to the forum.


I do not know if these questions are Excel 2008 related.

Do you really need/want a $ sign beside each number?
Try formatting the numbers to a different format and then try setting the format again with Tools|Cells|Number|Accounting

or use Custom number format
You could start with the following and adjust it to your preferences

_-$* #,##0.00_-;-$* #,##0.00_-;_-$* "-"??_-;_-@_-

I am not clear on your second question but you could try making the columns wider.

hth Dave