How to convert an exponential number for Google Sheets (error)

[L_Duperval]

Hi @Frederic_Pasman and welcome to the Make Community!

Assuming you have the correct value and that the “e-7” is not an error, maybe this post might help:

Scientific notation

This is an excellent question! Error when formatting scientific numbers Usually one would use the formatNumber function to display numbers as a string (text) [Screenshot_2023-09-04_160934] But when the number is a scientific notation, this throws an error [Screenshot_2023-09-04_160900] Failed to map ‘value’: Function ‘formatNumber’ finished with error! ‘1.0442665000000301e+21’ is not a valid number or using unsuitable separator. Why there is such an error These sort of numbers being dis…

L