1. You are viewing our forum as a guest. For full access please Register. WindowsBBS.com is completely free, paid for by advertisers and donations.

Regional Setting-Digit comma setting not getting enabled

Discussion in 'Other PC Software' started by rajesh0844, 2005/04/22.

Thread Status:
Not open for further replies.
  1. 2005/04/22
    rajesh0844

    rajesh0844 Inactive Thread Starter

    Joined:
    2005/04/22
    Messages:
    1
    Likes Received:
    0
    Under regional settings..I changed the comma settings from 1,000,000 to 1,00,000 ie from 3 zeros to two zero setting..but Excel does not reflect this change. Can anyone help !! :confused: :mad:
     
    rajesh0844,
    #1
  2. 2005/04/22
    Arie

    Arie Administrator Administrator Staff

    Joined:
    2001/12/27
    Messages:
    15,174
    Likes Received:
    412
    Check if Use system separators is checked in Excel under Tools > Options > International.
     
    Arie,
    #2


  3. to hide this advert.

  4. 2005/04/22
    Arie

    Arie Administrator Administrator Staff

    Joined:
    2001/12/27
    Messages:
    15,174
    Likes Received:
    412
    Also make sure that the cells are formatted as category Number and that Use 1000 Separator (,) is checked.

    Oh... tried it myself, & it doesn't work... maybe someone else knows :rolleyes:
     
    Arie,
    #3
Thread Status:
Not open for further replies.

Share This Page

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Accept Learn More...