$ or £'s

%3CLINGO-SUB%20id%3D%22lingo-sub-2610240%22%20slang%3D%22en-US%22%3E%24%20or%20%C2%A3's%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2610240%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%20I%20live%20in%20the%20UK%2C%20how%20can%20I%20change%20%24%20signs%20to%20%C2%A3's%20in%20an%20annual%20budget%20template.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2610240%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2610705%22%20slang%3D%22en-US%22%3ERe%3A%20%24%20or%20%C2%A3's%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2610705%22%20slang%3D%22en-US%22%3E%3CP%3EHello%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1120335%22%20target%3D%22_blank%22%3E%40fjr2320gmailcom%3C%2FA%3E%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThis%20could%20be%20accomplished%20within%20the%20number%20formats%20menu.%26nbsp%3B%20Press%20Ctrl%20%2B%201%20to%20open%20the%20number%20formats%20menu.%26nbsp%3B%20Go%20to%20%22Currency%22%2C%20click%20the%20drop-down%20list%20and%20select%20%22English%20(United%20Kingdom)%22.%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22PReagan_0-1628089510349.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F300525i44BD46B02C92B434%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22PReagan_0-1628089510349.png%22%20alt%3D%22PReagan_0-1628089510349.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2611205%22%20slang%3D%22en-US%22%3ERe%3A%20%24%20or%20%C2%A3's%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2611205%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1120335%22%20target%3D%22_blank%22%3E%40fjr2320gmailcom%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAside%20from%20the%20correct%20answer%20from%20Mr.%20Patrick%20Reagan%20(%40PReagan)%2C%20there%20is%20also%20the%20option%20of%20using%20keyboard%20shortcuts%20to%20quickly%20change%20a%20cell.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EKeyboard%20shortcuts%20Windows%20%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3BKeyboard%20shortcuts%20Mac%3C%2FP%3E%3CP%3E%24%20%E2%80%9CDollar%E2%80%9C%20%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%20Shift%20%2B%204%26nbsp%3B%20%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3BAlt%20%2B%20E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%C2%A3%20%E2%80%9CEnglish%20pound%E2%80%9C%20%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%20Alt%20%2B%200163%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%20Alt%20%2B%20Shift%20%2B%204%3C%2FP%3E%3CP%3E%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%20(Numeric%20keypad)%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20would%20be%20happy%20to%20know%20if%20I%20could%20help.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ENikolino%3C%2FP%3E%3CP%3EI%20know%20I%20don't%20know%20anything%20(Socrates)%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

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

3 Replies

Hello @fjr2320gmailcom,

 

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

PReagan_0-1628089510349.png

 

@fjr2320gmailcom 

Aside from the correct answer from Mr. Patrick Reagan (@PReagan), there is also the option of using keyboard shortcuts to quickly change a cell.

 

Keyboard shortcuts Windows                   Keyboard shortcuts Mac

$ “Dollar“           Shift + 4                                        Alt + E

 

£ “English pound“           Alt + 0163                      Alt + Shift + 4

              (Numeric keypad)

 

I would be happy to know if I could help.

 

Nikolino

I know I don't know anything (Socrates)

@fjr2320gmailcom 

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