twsKing

Hope that this one is going to be easy

How do i change the $ sign in the money section of excel into £, as I am in the UK?

Thanks for any help that you can give :approve:

kpc1

Well, in Pocket Excel, I come up with € , and I presume that is because I have Euro selected in my regional settings. I went to Start > Settings > System > Regional Settings > Currency, and changed $ to €. Strangely, I don't see any £ option, though!

davrol

1. Go to Settings\System\Regional Settings and select English (United Kingdom). Positive currency should then show £123,456,789.00. If it doesn't, go to the Currency Tab and select £ in the Currency symbol box.

2. Open Pocket Excel and open a new worksheet. Select a cell and go to Format\Cells\Number and select Currency in the Category box. Check the "use currency symbol" box. The Negative numbers box should show -£1,234.43.

kpc1

davrol, I thought of 1. before I replied, and changed to English (UK), but the £ sign was still not available on my machine.