Results 1 to 6 of 6

Decimal vs. Thousands Separator

Threaded View

nsv Decimal vs. Thousands... 12-22-2010, 04:52 AM
DonkeyOte Re: Decimal vs. Thousands... 12-22-2010, 05:11 AM
nsv Re: Decimal vs. Thousands... 12-22-2010, 09:01 AM
ChemistB Re: Decimal vs. Thousands... 12-22-2010, 10:07 AM
nsv Re: Decimal vs. Thousands... 12-22-2010, 04:34 PM
nsv Re: Decimal vs. Thousands... 12-28-2010, 06:05 AM
  1. #1
    Forum Contributor
    Join Date
    08-22-2005
    Location
    Denmark
    MS-Off Ver
    Excel 365
    Posts
    349

    Decimal vs. Thousands Separator

    I import an array of data from a text document to Excel; the array contains only numbers.
    The problem is that if a number has exactly three digits after the decimal the decimal separator is considered to be a thousands separator; thus 1.446 (one point four four six) becomes 1446 (one thousand four hundred forty six.

    Control panels regional and language options is set to decimal comma and point for thousands separator and that is fixed as it is a company owned computer with only IT-dept. access to such things. However, Excel operates with decimal point. I don't know this is set up.

    NSV
    Last edited by nsv; 12-28-2010 at 06:06 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