Importing decimal numbers on Excel

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

Hello everyone !

I don't know if this has been asked before, but I haven't found a topic about it so might a well ask it !

I have a problem with Power Automate Desktop and importing decimal numbers on Excel.

I have a flow that goes and gets a table from the Web and then saves it to Excel. My problem is that once the data is on Excel, I get an error that the decimal numbers are considered as text on Excel and not numbers, so I can't do operations with them on Excel without canceling the error by hand (which is not the point).

I have tried converting them to numbers on my flow, but no watter what i do Excel consideres them as text and not numbers.

It does not happen with int numbers though so i think the problem may be the comma ? The numbers are set like this "1,2" for example.

Could someone help me ?

Thank you very much in advance!

Categories:

Power Automate Desktop

All responses (2)

Answers (1)

Sort by

Verified answer

John_Mavridis Microsoft Employee on at

Like
a
(3)

Report
Copy link

Link copied!

Hi there,
This may be caused by the regional settings you use, in which the decimal operator is most probably the comma, as opposed to the dot character. This affects how Excel represents numeric values, but it does not affect how Power Automate Desktop handles them, as PAD uses the dot character for that purpose.

To work around this issue, you would need to slightly process the decimal numbers within PAD, before writing them in Excel. Specifically, assuming that these values already come in text format, as part of a table extracted from the web, you would need to use the 'Replace text' action on each of these values. In this action, you would need to replace the comma character (,) with the dot character (.) - the output of this action should then be in the proper format, which will be handled as a numeric value when sent to Excel.

Let us know if this works for you.
Thanks!
Community Power Pla... Microsoft Employee on at

Like
a
(1)

Report
Copy link

Link copied!

Hello !

Thank you so much for your answer !

Yes it actually worked ! I didn't think it would because Excel doesn't take it as a number when i type in "1.2" by hand but it works with PAD ! So thank you again !