Forum Discussion
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
Microsoft 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.
- AnonymousNot applicable
Thank you so much!