csv import strange value such as “6E-8”
Spreadsheet csv import strange value such as “6E-8” 😳🧐 for csv import and Google does not return a suitable result. Here is the solution!
Well, it’s basically easy to solve. Google returns incorrect results because the question was most likely asked incorrectly! 😂
To put it bluntly, it is an exponential representation of a number. This strange value is not an error, but contains the number or value you are looking for.
Video: csv import strange value such as “6E-8”
Language: 🇩🇪
☝️ Use YouTube subtitles for all languages.
For example: 6E-8
The value is 6, as can be seen in the representation “6x-x”.
The number begins with 8 zeros, corresponding to the representation “xE-8” or exponential-8.
Our number is therefore 000000008 and only the decimal point is missing: 0.00000008 – perfect!
In the video, I show you how to set this up in a spreadsheet without converting or rewriting every value.
Link to support / donation for the channel
PayPal Link
Bank transfer, Bitcoin and Lightning
#csvImport #spreadsheet #Numbers #LibereCalc #Excell #spreadsheet #Exponential
