Unanswered

Turn off scientific notation in power-automate

(3) Share

Report

Posted on by Muneeb

I am generating an excel file using the Select operation but it is automatically converting numbers into E+ format. How can I stop this behavior in the power automate?

Categories:

General topics

I have the same question (0)

All responses (12)

Answers (0)

Addon 52 on at

Like (0)

Report

I have the same issue, has anybody resolve it?

Was this reply helpful? Yes No
bretmanrock Microsoft Employee on at

Like (0)

Report

I have same issue can you help us.

Was this reply helpful? Yes No
E_Wood 3 on at

Like (0)

Report

I also am having this issue.

Was this reply helpful? Yes No
Paulburn 2 on at

Like (0)

Report

do a string function around your number.

Was this reply helpful? Yes No
Mel1Mel0 28 on at

Like (0)

Report

It does not work. Be it the string function or '' or putting it inside a string variable... it is still considered number by excel and transformed into scientific notation which make me lose the end of the number also

Was this reply helpful? Yes No
WillPage 2,307 Super User 2025 Season 2 on at

Like (0)

Report

Simply convert to integer with the int() function:

Was this reply helpful? Yes No
Chriddle 8,436 Super User 2025 Season 2 on at

Like (0)

Report

This is not Power Automate.

Change the column format in your Excel file.

Was this reply helpful? Yes No
WillPage 2,307 Super User 2025 Season 2 on at

Like (0)

Report

That's a pretty unhelpful comment. You don't always have control of the data you need to process and it absolutely is a thing you can solve easily in power automate because its numerical conversion functions can handle scientific notation natively.

Was this reply helpful? Yes No
Chriddle 8,436 Super User 2025 Season 2 on at

Like (0)

Report

Please explain. I'm not aware of such "numerical conversion functions" in Power Automate.

From what I understand, the OP's problem is that Excel displays large numbers in scientific notation when the cell format is set to "General".

If you set this to "Number", the issue is solved.

Was this reply helpful? Yes No
WillPage 2,307 Super User 2025 Season 2 on at

Like (0)

Report

Look at my response to the question. It's directly above yours

Was this reply helpful? Yes No