+ Reply to Thread
Results 1 to 7 of 7

currency convertor issue

Hybrid View

  1. #1
    Forum Guru DonkeyOte's Avatar
    Join Date
    10-22-2008
    Location
    Northumberland, UK
    MS-Off Ver
    O365
    Posts
    21,531

    Re: currency convertor issue

    I don't think that would work (in all scenarios) given it would be dependent upon client locale.

    For ex. this works for you because € is default system currency thus cells formatted as Euro's return a cell format of C# (where # is determined by decimals used) whereas all other currencies return ,#, however, in the UK given £ is default system currency both Euro and USD would return ,# and only £ would return C#

    Also given # you would probably want to revise the approach to check only for existence of C in format given the no. of decimals may vary.

    (If the client is set to use $ as system currency then (reversed) it could work of course)
    Last edited by DonkeyOte; 10-01-2009 at 04:53 AM. Reason: added in all scenarios as it could work in some for sure...

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1