Results 1 to 5 of 5

Set local number format from Dutch format Number

Threaded View

  1. #1
    Forum Contributor
    Join Date
    02-14-2007
    Location
    Chester, England
    MS-Off Ver
    2010 & 2016
    Posts
    312

    Set local number format from Dutch format Number

    Hi All

    I have written a script that takes a string and removes the 3 characters at the front. After the 3 characters have been removed I would like to display the remaining as a value with 2 decimal places.

    The only problem is that string shows the number in the Dutch format e.g. EUR5.000,00

    Is it possible to format the remaining as a number to 2 decimal places acording to the machine it was run on? e.g. if it was run in the UK it would show 5,000.00 and if it was run on the Netherlands it would show 5.000,00.

    Also if this was run in the Netherlands does anyone know if this example would automatically convert it to a number?

    I hope someone can help!

    Thanks in advance

    Jim
    Last edited by JimmyA; 11-23-2012 at 07:41 AM.

Thread Information

Users Browsing this Thread

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

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