ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Align dollar symbol, align currency symbol... (https://www.excelbanter.com/excel-discussion-misc-queries/182999-align-dollar-symbol-align-currency-symbol.html)

Mark

Align dollar symbol, align currency symbol...
 
Does anyone know how to align the currency symbol in a spreadsheet? The
currency values are right aligned so that the decimals line up. There is
another alignment, alignment of the currency symbol to the widest currency
value in the spreadsheet. It is called a float currency alignment. All the
postings in Google are for school projects and none actually have the
answer. Can anyone tell me how to do that?

FSt1

Align dollar symbol, align currency symbol...
 
hi
change the format from currancy to accounting.

Regards
FSt1

"Mark" wrote:

Does anyone know how to align the currency symbol in a spreadsheet? The
currency values are right aligned so that the decimals line up. There is
another alignment, alignment of the currency symbol to the widest currency
value in the spreadsheet. It is called a float currency alignment. All the
postings in Google are for school projects and none actually have the
answer. Can anyone tell me how to do that?



All times are GMT +1. The time now is 03:44 AM.

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