--
Wayne in Seattle

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

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

Thank you for your help,

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,

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

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,