currency symbol not aligned

highpixel

New Member
Joined
Jun 16, 2009
Messages
1
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!!!
 

Excel Facts

Ambidextrous Undo
Undo last command with Ctrl+Z or Alt+Backspace. If you use the Undo icon in the QAT, open the drop-down arrow to undo up to 100 steps.
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
 
Upvote 0

Forum statistics

Threads
1,213,494
Messages
6,113,981
Members
448,538
Latest member
alex78

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top