Alpha Video Training
Results 1 to 1 of 1

Thread: Entering amounts with decimals

  1. #1
    Member Ton Spies's Avatar
    Real Name
    Ton Spies
    Join Date
    Apr 2002
    Location
    Leeuwarden, The Netherlands
    Posts
    555

    Default Entering amounts with decimals

    Hi EuroAlphaholics

    At the right side of a enhanced keyboard is a keypath. Usefull special for numeric input. There is also decimal (dot)key.
    When entering an amount with decimals at the keypath e.g. 123.45 will be treated in Excel as 123,45

    Has one of you ever tried to accomplish in Alpha the acceptance of the dot entered from the keypath to be treated as comma?

    However I tried to make a function for that, the only way I can get this done is in the fieldrules with: a_field_value.value= chrtran(a_field_value.value,".",",")
    I could not get it fiexed because of the initial interpretation N or C type of the input and also as the Interactive window does not work with regional settings.

    Interested how you guys do handle this.

    Regards,
    Ton
    Last edited by Ton Spies; 05-31-2009 at 12:19 PM.

Similar Threads

  1. Check amounts
    By Ed Barley in forum Alpha Five Version 5
    Replies: 8
    Last Post: 11-19-2003, 02:31 PM
  2. Charging different customers different amounts ?
    By Ciaran in forum Alpha Five Version 4
    Replies: 10
    Last Post: 03-28-2003, 03:36 AM
  3. Keep Previous Rate / Amounts
    By forskare in forum Alpha Five Version 5
    Replies: 10
    Last Post: 01-05-2003, 04:26 PM
  4. User Amounts
    By Robert erickson in forum Alpha Five Version 4
    Replies: 2
    Last Post: 06-23-2002, 05:32 PM
  5. Totalling amounts on a report
    By Norm Ferguson in forum Alpha Five Versions 2 and 3
    Replies: 3
    Last Post: 06-29-2000, 04:05 PM

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
  •