Dashboard currency

[EddieNelson]

Simple question how do I change the currency in the dashboard from $ to £ ?


Eddie

 

[DaveTurton]

right click - format cells - number tab - currency - change the currency sign

 

[EddieNelson]

Hi Dave,


Thank you, I was trying to change the currency on the dashboard. I've changed the currency in the cells but this isn't reflected in the dashboard :-(

 

[DaveTurton]

Have you changed the currency in the cells on the dashboard not just in the sheet you are using for data/calculation

 

[EddieNelson]

Hi,


No I haven't how do I do that? the sheet appears to be protected

 

[DaveTurton]

I'm guessing this isn't a dashboard you have created yourself?


excel 2003 - tools - protection - unprotect sheet


excel 2007+ - Home tab - Format - unprotect sheet


if it asks for a password then you need to contact the author

 

[EddieNelson]

Cheers