changing currency from Dollar to Pounds Sterling

L

Lee

In Microsoft Excel I want to change the currency from Dollar to Pounds
Sterling does anyone know how?
 
H

hally

click on the cell you want to change right click format cell, under catogory
choose currency then change symbol on the right hand side
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Currency formatting problem - Excel 2003 1
I wish to enter pounds shillings and pence in sterling 1
How to calculate total cost using fixed hourly rate from [h:mm:ss:]? 4
How do i download UK version of the Invoice template ? 3
How do I convert pounds to stones eg 200 pounds is 14 stone 4 lb 4
Change currency in table 4
How do I calculate and display in British Pounds and/or Euros? 4
Dollar amounts aren't merging from Excel into a Word document... 3

Top