How do I calculate and display in British Pounds and/or Euros?

[Staeger]

We have recently taken our business to Europe. One of the spreadsheets we use
is a Job Profitability Plan that tracks the value of the contract as it
relates to number of hours worked on the project. The number of hours
rolls-up into a dollar value for stateside work. We need to replicate the
spreadsheet and have it calculate Pounds Sterling for the U.K. and euros for
the rest of Europe.

[Bearacade]

If you just want to make the number appear as Euros or GBPs, you can just use cell format, Currency and Symbol.

If you are taking exisiting Data, and need to convert it into those currencies, you would need to work out a formula for the exchange rates.

[Bernard Liengme]

Not clear what you mean by 'calculate'. If the values are computed first in
US dollars and you want to convert then you will need to now today's
exchange rate. Find this on Internet.

Otherwise, if all values are in pounds, just do the math the normal way (but
you must raise you pinkie when typing!)

To display just pick a format with £ or ? from Excel's Currency format
dialog (at least in XL 2003).

In many European countries one writes 10,50? rather than ?10.50 (symbol is
post rather than pre, and decimal symbol is comma not period)
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Staeger" <[email protected]> wrote in message
news:[email protected]...
> We have recently taken our business to Europe. One of the spreadsheets we
> use
> is a Job Profitability Plan that tracks the value of the contract as it
> relates to number of hours worked on the project. The number of hours
> rolls-up into a dollar value for stateside work. We need to replicate the
> spreadsheet and have it calculate Pounds Sterling for the U.K. and euros
> for
> the rest of Europe.

[Staeger]

This was helpful...thank you.

"Bearacade" wrote:

>
> If you just want to make the number appear as Euros or GBPs, you can
> just use cell format, Currency and Symbol.
>
> If you are taking exisiting Data, and need to convert it into those
> currencies, you would need to work out a formula for the exchange
> rates.
>
>
> --
> Bearacade
>
>
> ------------------------------------------------------------------------
> Bearacade's Profile: http://www.excelforum.com/member.php...o&userid=35016
> View this thread: http://www.excelforum.com/showthread...hreadid=551159
>
>

[Staeger]

This was helpful...thank you.

"Bernard Liengme" wrote:

> Not clear what you mean by 'calculate'. If the values are computed first in
> US dollars and you want to convert then you will need to now today's
> exchange rate. Find this on Internet.
>
> Otherwise, if all values are in pounds, just do the math the normal way (but
> you must raise you pinkie when typing!)
>
> To display just pick a format with £ or ? from Excel's Currency format
> dialog (at least in XL 2003).
>
> In many European countries one writes 10,50? rather than ?10.50 (symbol is
> post rather than pre, and decimal symbol is comma not period)
> best wishes
> --
> Bernard V Liengme
> www.stfx.ca/people/bliengme
> remove caps from email
>
> "Staeger" <[email protected]> wrote in message
> news:[email protected]...
> > We have recently taken our business to Europe. One of the spreadsheets we
> > use
> > is a Job Profitability Plan that tracks the value of the contract as it
> > relates to number of hours worked on the project. The number of hours
> > rolls-up into a dollar value for stateside work. We need to replicate the
> > spreadsheet and have it calculate Pounds Sterling for the U.K. and euros
> > for
> > the rest of Europe.
>
>
>