ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Currency button (https://www.excelbanter.com/excel-worksheet-functions/53358-currency-button.html)

Alex H

Currency button
 
Hi, I am working on a spreadsheet from a colleague in the US.

If I select a cell and then click on the currency button, I am getting the
$ sign and not the UK £ sign. How do I change the default for this button
please?

Thanks
A



Gary L Brown

Currency button
 
FormatStyleCurrencyModifySymbol

HTH,
--
Gary Brown

If this post was helpful, please click the ''''Yes'''' button next to
''''Was this Post Helpfull to you?".


"Alex H" wrote:

Hi, I am working on a spreadsheet from a colleague in the US.

If I select a cell and then click on the currency button, I am getting the
$ sign and not the UK £ sign. How do I change the default for this button
please?

Thanks
A





All times are GMT +1. The time now is 01:59 PM.

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