Changing language of an existing sheet

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a spreadsheet from a colleague in the USA and the currency cells show
the USD ($) symbol, though I need it to be in GBP (£) as I will use it in the
UK.

My PC is fully UK configured.

How can I change this sheet?
 
Right click on any cell with the dollar sign and select Format Cell. On the
left pane, select Currency. On the right of the dialog under "Symbol:" click
the drop down and a list of foreign currency symbols will appear. Scroll down
to the pound symbol for United Kingdom. This should work for any currency.
Good luck!!
 
It may be as simple as changing the cell format for the currency cells:
click >Format >Cells and choose the Number tab; in the Symbol dropdown,
select pounds sterling.
 
Jim,

Ignore my ramblings..... I had suffered a senior moment.... I've only been
working with Excel since the early '90s so it is all a bit new to me ;-)

As soon as I wrote the post I knew what a fool I had been. I was looking for
a format language as in Word.!!!!

Old dogs and new tricks, eh?
 
Back
Top