ExcelBanter - changing currency from Dollar to Pounds Sterling

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - changing currency from Dollar to Pounds Sterling (https://www.excelbanter.com/excel-discussion-misc-queries/26643-changing-currency-dollar-pounds-sterling.html)

Lee

changing currency from Dollar to Pounds Sterling

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

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

"Lee" wrote:

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

All times are GMT +1. The time now is 12:42 AM.