Excel Importer Decimal Format conversion with comma and dot

0
Hi guys,   Recently we have faced an issue with excel importer for decimal field conversion for the number below 10,00,000. In the excel file we are using this format(_-* #,##0_-;-* #,##0_-;_-* "-"??_-;_-@_-) set to Custom for the excel cell and this cell is imported using excel importer and it converts the 1000 separator values like 10,000 to 100, 23558 to 24 and 9,45,000 to 945.   Thanks in Advance and please help me on this.
asked
2 answers
0

Hi, 

Please check this similar post.

 

Hope it helps,

João

answered
0

You can try following 

Set Excel column format to plain Number without separators before import.

Or import the value as String and use a microflow/Java action to strip separators and convert to Integer.

answered