Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

PQ doesn't recognize value '0,76' as decimal number

Greetings

 

I import a file containing all the invoices in my organisation spanning a certain period. When I convert the column containing the amounts to a decimal number, I receive a single error for a cell: it seems PQ refuses to convert the value '0,76' to a decimal number. This is the only amount in the column less than €1 (i.e., having a 0 before the comma). I also tried to convert the column to type 'currency' or 'whole number' but I keep receiving the error. When opening the .csv in Excel the number in the cell is correctly displayed and recognized as '0,76', so nothing funky going on there. This is the full error message I get from PQ when clicking on the 'error' hyperlink:

"DataFormat.Error: We couldn't convert to Number.
Details:
,76"

 

Anyone know how to fix this? Greetings.

  • In the menu, go to options, then under current file choose regional settings. Pick a Eurpoean country (not UK). Then hit refresh preview in your query.

2 Replies

  • artemus's avatar
    artemus
    Icon for Microsoft Employee rankMicrosoft Employee

    In the menu, go to options, then under current file choose regional settings. Pick a Eurpoean country (not UK). Then hit refresh preview in your query.

    • Anonymous's avatar
      Anonymous
      Not applicable

      Thank you so much!