move the $ signs on Excel spreadsheet to the right (closer to #

[Sharla]

My spreadsheet looks terrible. The currency signs are left alligned in the
excel cells, and I can't get them to move over near my dollar ammounts on the
right, even when I try right alligning the cells.

 

[Kevin B]

It sounds like you're using Accounting formatting in your spreadsheet. Which
is the formatting assigned by the currency button on the formatting toolbar.

Select the cells you want to format, click FORMAT in the menu and select
CELLS. If necessary click the NUMBER tab. In the list of format categories
select CURRENCY. Set your decimals to whatever you need, with 2 being the
default.

 

[Mike Middleton]

Sharla -

Don't use the Currency button on the Formatting tool bar.

Instead, choose Format | Cells | Number | Currency ...

- Mike
http://www.mikemiddleton.com

 

[RhysPieces]

What about changing the properties of the Currency button so the $ sign
aligns with the currency values? If so, how? Seems it would be fewer clicks
if you think about it.

 

[Gord Dibben]

RhysPieces

Copy this macro into your Personal.xls

Sub Curr_Format()
Selection.NumberFormat = "$#,##0.00"
End Sub

Then Tools>Customize.

Right-click the $ Icon and assign the macro to that Icon.


Gord Dibben MS Excel MVP

 

[Sharla]

Thank you so much!

It sounds like you're using Accounting formatting in your spreadsheet. Which
is the formatting assigned by the currency button on the formatting toolbar.

Select the cells you want to format, click FORMAT in the menu and select
CELLS. If necessary click the NUMBER tab. In the list of format categories
select CURRENCY. Set your decimals to whatever you need, with 2 being the
default.

 

[Sharla]

Thank you so much!

Sharla -

Don't use the Currency button on the Formatting tool bar.

Instead, choose Format | Cells | Number | Currency ...

- Mike
http://www.mikemiddleton.com