View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Wayne in Seattle Wayne in Seattle is offline
external usenet poster
 
Posts: 2
Default 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,