Results 1 to 2 of 2

data import and decimal separator interpretation

Threaded View

  1. #1
    Registered User
    Join Date
    02-22-2018
    Location
    Brazil
    MS-Off Ver
    1801
    Posts
    41

    data import and decimal separator interpretation

    Hello

    I have some tables under .txt format I am trying to import through data > new query > from file > from folder. The decimal separator is ".", but after I combine the tables the separator is interpreted as ",", and my values become messed. Because my default decimal separator is already defaulted to ".", I don't know what is the problem. Here are two screenshots of the problem.

    The first picture is the correct one, and the second is the problem.
    Attached Images Attached Images

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Import CSV to Data Model - Change decimal separator
    By jawaka in forum Excel Charting & Pivots
    Replies: 23
    Last Post: 12-06-2017, 10:44 AM
  2. [SOLVED] Data extraction problem (decimal separator)
    By Villalobos in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 08-25-2017, 04:47 AM
  3. Decimal separator in charts
    By AivarsK in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 04-21-2016, 11:51 AM
  4. Replies: 4
    Last Post: 09-06-2012, 07:51 AM
  5. Getting decimal separator
    By Helge in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 06-01-2011, 08:23 AM
  6. Decimal vs. Thousands Separator
    By nsv in forum Excel General
    Replies: 5
    Last Post: 12-28-2010, 06:05 AM
  7. Replies: 1
    Last Post: 09-08-2005, 07:05 PM

Tags for this Thread

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