Forum Discussion
phil4arsenal2
Dec 30, 2022Copper Contributor
excel work book
good evening everybody
i have just started using excel and i am in the process of creating monthly expense sheet and i came across a work sheet but it is in $ and i am in the uk and use pounds so my question is ,is there anyway i can change the formula to £
thankyou in advance
phil
Select the cells with a currency amount.
On the Home tab of the ribbon, in the Number group, click the arrow on the right hand side of the Accounting Number Format button and select '£ English (United Kingdom)' from the drop down list.