Hello all,
I have a problem with creating a flow in Power Automate Desktop. I need to read data from an excel file, this works in principle but there are problems with the formatting of numbers. The values to be read are numbers with decimal places in Euro.
In Excel the number format is set to currency. This leads to a value with two decimal places being displayed in the Excel cell. However, Excel saves only one decimal place if the second decimal place is a zero. For example "5,10" becomes "5,1". Now I am of course missing the second decimal place after reading it into PowerAutomateDesktop. Does anyone have an idea how I can get the number with two decimal places? I have the same problem when the number is "5,00", then I get only "5".
Greetings
Johannes
