Share
ReportI 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?
You’re offline. This is a read only version of the page.
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?
If changing Excel's column format is not an option (you have to stick with "General"), you can provide Excel with a string value (with the disadvantage that it is no longer a number in Excel 😉)
An example:
All responses (
Answers (
concat('''', 100000000000)
In Excel this looks like tthis:
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.
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.
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
#1
WarrenBelz
146,668
Most Valuable Professional
#2
RandyHayes
76,287
Super User 2024 Season 1
#3
Pstork1
66,004
Most Valuable Professional
