ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   move the $ signs on Excel spreadsheet to the right (closer to (https://www.excelbanter.com/excel-discussion-misc-queries/115932-re-move-%24-signs-excel-spreadsheet-right-closer.html)

Sharla

move the $ signs on Excel spreadsheet to the right (closer to
 
Thank you so much!

"Kevin B" wrote:

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.

--
Kevin Backmann


"Sharla" wrote:

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.



All times are GMT +1. The time now is 07:34 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com