View Single Post
  #2   Report Post  
Ron Rosenfeld
 
Posts: n/a
Default

On Fri, 12 Aug 2005 01:21:06 -0700, "funmi_Bash"
wrote:

Hello Microsft Excel Developers,

I would like Microsoft to extend the capabilities of Excel by providing a
worksheet function that will return the currency value of the contents of a
cell. I have found this necessary and useful when confronted with arrays that
have values of many different currencies.

Looking forward to your kind assistance on this issue. Thank tou.

A. O. O. Basorun
The Basorun Clan,


You could easily write a VB function to return the currency identifier used in
any particular cell. There also may be a three character code returned by the
NumberFormat property of the cell which can be translated to a country.
However, I am unable to locate that conversion list.


--ron