Decimal point is lost when I import .csv file with Query in Excel2016 RRS feed

  • Question

  • Imported via Data/From text: decimal is retained

    Imported via Query in excel 2016: decimal point is lost:

    What can I do to retain decimal point via query import?

    Thnx for help!

    Sunday, April 23, 2017 9:57 AM


  • Probably you are using a culture code (or Locale) - Dutch? - that uses decimals commas instead of decimal points.

    There should be a "Changed Type" step in you code in which you can add a culture code that uses decimals points:
    e.g. add: , "en-US" just before the last close-parenthesis, so the last part of the formula reads: }}, "en-US")

    Sunday, April 23, 2017 10:32 AM

All replies