Change currency in Excel

  Birder 1 16:31 09 Apr 2004
Locked

How do i change the currency from dollars to sterling

  VoG II 16:33 09 Apr 2004

Settings in Control Panel. In Windows XP, Regional and Language settings.

  zebbydog 17:00 09 Apr 2004

open sheet click format cells currency and change it to £ sign

  pj123 20:14 09 Apr 2004

As an add-on to zebbydog. You would need to highlight the column that contains the values first before formatting them.

This thread is now locked and can not be replied to.

Elsewhere on IDG sites

Best Amazon Echo: What’s the best Alexa speaker?

Kano Computer Kit Complete review: A fun DIY 'laptop' that teaches kids to code

Best pro photo editors for Mac 2018

TV & streaming : comment regarder les Jeux olympiques d’hiver 2018 ?