ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   English Currency Types (https://www.excelbanter.com/excel-worksheet-functions/127920-english-currency-types.html)

Wayne in Seattle

English Currency Types
 

--
Wayne in Seattle

What is the difference in Excel, under Format Cells, Number tab:

$
$ English (United States)
$ English (Canada)

Thank you for your help,

Dave F

English Currency Types
 
Many countries, including the US and Canada use $ as the symbol for their
currency. $ therefore is a generic symbol used when a spreadsheet only
considers one dollar-denominated currency.

If a spreadsheet is contemplating an investment of American dollars in a
Canadian company, then you need separate symbols to differentiate between the
two countries' currency. Just wait till you have a model contemplating
Australian, Singaporean, American, and Canadian equities.

Dave
--
Brevity is the soul of wit.


"Wayne in Seattle" wrote:


--
Wayne in Seattle

What is the difference in Excel, under Format Cells, Number tab:

$
$ English (United States)
$ English (Canada)

Thank you for your help,


Bernard Liengme

English Currency Types
 
This does not explain why there are £ (UK) and £ (Welsh)
But there is no £ (Scottish) nor £ (Isle of Man) nor £ (Channel Islands)
I think the reason is more subtle than you suggest
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Dave F" wrote in message
...
Many countries, including the US and Canada use $ as the symbol for their
currency. $ therefore is a generic symbol used when a spreadsheet only
considers one dollar-denominated currency.

If a spreadsheet is contemplating an investment of American dollars in a
Canadian company, then you need separate symbols to differentiate between
the
two countries' currency. Just wait till you have a model contemplating
Australian, Singaporean, American, and Canadian equities.

Dave
--
Brevity is the soul of wit.


"Wayne in Seattle" wrote:


--
Wayne in Seattle

What is the difference in Excel, under Format Cells, Number tab:

$
$ English (United States)
$ English (Canada)

Thank you for your help,




Wayne in Seattle

English Currency Types
 

--
Wayne in Seattle

Thank you Dave, that makes sense. Also, thank you for keeping it concise.

Cheers,

Wayne

"Dave F" wrote:

Many countries, including the US and Canada use $ as the symbol for their
currency. $ therefore is a generic symbol used when a spreadsheet only
considers one dollar-denominated currency.

If a spreadsheet is contemplating an investment of American dollars in a
Canadian company, then you need separate symbols to differentiate between the
two countries' currency. Just wait till you have a model contemplating
Australian, Singaporean, American, and Canadian equities.

Dave
--
Brevity is the soul of wit.


"Wayne in Seattle" wrote:


--
Wayne in Seattle

What is the difference in Excel, under Format Cells, Number tab:

$
$ English (United States)
$ English (Canada)

Thank you for your help,



All times are GMT +1. The time now is 10:48 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com