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

 > 

  • Question

  • Question
    Sign in to vote
    0
    Sign in to vote

    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

Answers

  • Question
    Sign in to vote
    1
    Sign in to vote

    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

  • Question
    Sign in to vote
    1
    Sign in to vote

    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
  • Question
    Sign in to vote
    1
    Sign in to vote

    Hi there. This article contains some tips on dealing with common culture/locale issues.

    Ehren


    Monday, April 24, 2017 11:12 PM