+ Reply to Thread
Results 1 to 2 of 2

Strange behaviour decimal sign numeric keypad

  1. #1
    Registered User
    Join Date
    09-29-2010
    Location
    Koudekerk a/d Rijn, Netherlands
    MS-Off Ver
    Office 2010
    Posts
    20

    Strange behaviour decimal sign numeric keypad

    Hi,



    My international settings are set to "Dutch" / Keyboard Settings = US-International

    So if I enter decimal numbers into my worksheet, the "point" from the numeric keypad is automatically "converted" to a "comma".
    So far so good

    I created a userform for entering numbers, those are stored on a worksheet.
    The strange thing here is, that if I enter decimal numbers with the numeric keypad, the "point" will actually stay as a point, and
    now my entered number is no longer recognized as a number, but it shows as a text value.

    How can I change the behaviour of entering the "point" on the numeric keypad into a comma?

    Thanks,
    Erik

  2. #2
    Forum Expert OllieB's Avatar
    Join Date
    12-20-2012
    Location
    Netherlands
    MS-Off Ver
    Excel 2007 (home) & 2010 (office)
    Posts
    1,542

    Re: Strange behaviour decimal sign numeric keypad

    Hi Erik, all user input in a textbox on a UserForm is considered text and not a numeric value, so if you want to store or process it as a numeric value you have to manipulate the value yourself.
    If you like my contribution click the star icon!

+ Reply to Thread

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