Forum Discussion

Saul57's avatar
Saul57
Copper Contributor
May 05, 2021
Solved

In the excel personal monthly budget how do I change the $ symbol to £?

Does anyone know how to change the symbols  from Dollars to pounds sterling? I use a surface running windows 10

  • Saul57 Is it this one?

    If so, select the little square with a triangle in it, in the top left corner of the grid (i.e. above the 1 and left of the A) to select the entire sheet. Then, on the Home ribbon, choose the Accounting format with the Pound symbol.

2 Replies

  • Riny_van_Eekelen's avatar
    Riny_van_Eekelen
    Platinum Contributor

    Saul57 Is it this one?

    If so, select the little square with a triangle in it, in the top left corner of the grid (i.e. above the 1 and left of the A) to select the entire sheet. Then, on the Home ribbon, choose the Accounting format with the Pound symbol.

    • Saul57's avatar
      Saul57
      Copper Contributor
      Yes got it at last !! thank you so much for the help i was going gaga trying to change it.

Resources