Forum Discussion

phil4arsenal2's avatar
phil4arsenal2
Copper Contributor
Dec 30, 2022

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

  • phil4arsenal2 

    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.

Resources