+ Reply to Thread
Results 1 to 4 of 4

Comma problem

  1. #1
    Registered User
    Join Date
    05-29-2010
    Location
    Brazil
    MS-Off Ver
    Excel 2003
    Posts
    1

    Comma problem

    Hi i'm new here, sorry if i broke any rule of this forum.

    I'm not from america so i dont use Dot to separate decimal, i use comma (,). My problem is when i type 1,92313 my excel change it to 192313,000 and if i type 1,92 it appears 1,920 some1 can solve this for me?

  2. #2
    Forum Expert
    Join Date
    12-23-2006
    Location
    germany
    MS-Off Ver
    XL2003 / 2007 / 2010
    Posts
    6,326

    Re: Comma problem

    Have you adapted your Regional settings?

  3. #3
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2010, 2019
    Posts
    40,689

    Re: Comma problem

    Assuming your Control Panel regional settings are set up for that, Tools > Options > Intenational, tick Use system separators
    Entia non sunt multiplicanda sine necessitate

  4. #4
    Forum Expert teylyn's Avatar
    Join Date
    10-28-2008
    Location
    New Zealand
    MS-Off Ver
    Excel 365 Insider Fast
    Posts
    11,375

    Re: Comma problem

    I think this is a setting to automatically insert a decimal separator.

    Tools - Options - Edit - uncheck Fixed Decimal

    cheers

+ 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