$ or £'s

Question

Hi, I live in the UK, how can I change $ signs to £'s in an annual budget template.

preagan · Answer

Hello&nbsp;fjr2320gmailcom,&nbsp;This could be accomplished within the number formats menu.&nbsp; Press Ctrl + 1 to open the number formats menu.&nbsp; Go to "Currency", click the drop-down list and select "English (United Kingdom)".&nbsp;

nikolinode · Answer

fjr2320gmailcom&nbsp;Aside from the correct answer from Mr. Patrick Reagan (@PReagan), there is also the option of using keyboard shortcuts to quickly change a cell.&nbsp;Keyboard shortcuts Windows &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Keyboard shortcuts Mac$ “Dollar“ &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Shift + 4&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Alt + E&nbsp;£ “English pound“ &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Alt + 0163&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Alt + Shift + 4&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; (Numeric keypad)&nbsp;I would be happy to know if I could help.&nbsp;NikolinoI know I don't know anything (Socrates)

sergeibaklan · Answer

fjr2320gmailcom&nbsp;
If you live in UK why don't you change regional settings for currency form dollar to pound?

Forum Discussion

$ or £'s

3 Replies

Resources