PDA

View Full Version : dollars to pounds


mally
December 9th 03, 12:25 PM
I have Windows XP Home, have tried to prepare a=20
spreadsheet for accounts but the only options I have for=20
currency are either US Dollars or the Euro.
Does anyone know how I can apply British Stirling (=A3's)=20
as an alternative or a default without having to enter=20
the =A3 symbol every time I enter figures in a cell.
Here's hoping someone knows - Mally

Chris Lanier
December 9th 03, 12:25 PM
YTou need to post this in the Excel Newsgroups if thats what you are using
news:microsoft.public.excel.misc

XE.com - The Universal Currency Converter
http://www.xe.com/ucc/

"mally" > wrote in message
...
I have Windows XP Home, have tried to prepare a
spreadsheet for accounts but the only options I have for
currency are either US Dollars or the Euro.
Does anyone know how I can apply British Stirling (£'s)
as an alternative or a default without having to enter
the £ symbol every time I enter figures in a cell.
Here's hoping someone knows - Mally

Alex Nichol
December 9th 03, 01:19 PM
mally wrote:

>I have Windows XP Home, have tried to prepare a=20
>spreadsheet for accounts but the only options I have for=20
>currency are either US Dollars or the Euro.
>Does anyone know how I can apply British Stirling (=A3's)=20
>as an alternative or a default without having to enter=20
>the =A3 symbol every time I enter figures in a cell.

Which spreadsheet program are you using? None is part of Windows XP,
and I guess you are probably using the Microsoft Works suite that comes
bundled with some new machines. Using Excel from Microsoft Office, if I
take Format - Cells then either Currency or Accounting provides for
every currency known, and then some.


--=20
Alex Nichol MS MVP (Windows Technologies)
Bournemouth, U.K.

Google