how to convert scientifical number to general number format

Lacampeona

New Member
Joined
Mar 31, 2024
Messages
7
Office Version
  1. 2016
Platform
  1. Windows
hello
I have a table with raw data which contains also scientifical number format.
How to convert that scientifical number format to general number?
can someone show me some examaple?
thank you

1,67E+01​
5,49E-01​
1,71E+01​
5,61E-01​
1,75E+01​
5,73E-01​
1,79E+01​
5,86E-01​
1,83E+01​
5,99E-01​
1,87E+01​
6,12E-01​
1,91E+01​
6,26E-01​
1,95E+01​
6,39E-01​
2,00E+01​
6,54E-01​
2,04E+01​
6,68E-01​
2,09E+01​
6,83E-01​
2,13E+01​
6,99E-01​
2,18E+01​
7,14E-01​
2,23E+01​
7,31E-01​
2,28E+01​
7,47E-01​
2,33E+01​
7,64E-01​
2,39E+01​
7,82E-01​
2,44E+01​
8,00E-01​
2,50E+01​
8,18E-01​
2,56E+01​
8,37E-01​
2,61E+01​
8,56E-01​
2,67E+01​
8,76E-01​
2,74E+01​
8,97E-01​
2,80E+01​
9,18E-01​
2,87E+01​
9,39E-01​
2,94E+01​
9,62E-01​
3,01E+01​
9,84E-01​
3,08E+01​
1,01E+00​
3,15E+01​
1,03E+00​
3,23E+01​
1,06E+00​
3,30E+01​
1,08E+00​
3,38E+01​
1,11E+00​
3,46E+01​
1,13E+00​
3,55E+01​
1,16E+00​
3,64E+01​
1,19E+00​
3,72E+01​
1,22E+00​
3,81E+01​
1,25E+00​
3,91E+01​
1,28E+00​
4,00E+01​
1,31E+00​
4,10E+01​
1,34E+00​
4,20E+01​
1,38E+00​
4,30E+01​
1,41E+00​
4,41E+01​
1,44E+00​
4,52E+01​
1,48E+00​
4,63E+01​
1,52E+00​
4,74E+01​
1,55E+00​
4,86E+01​
1,59E+00​
4,98E+01​
1,63E+00​
5,10E+01​
1,67E+00​
5,23E+01​
1,71E+00​
5,36E+01​
1,75E+00​
5,49E+01​
1,80E+00​
5,62E+01​
1,84E+00​
5,76E+01​
1,89E+00​
5,91E+01​
1,93E+00​
6,05E+01​
1,98E+00​
6,20E+01​
2,03E+00​
6,35E+01​
2,08E+00​
6,51E+01​
2,13E+00​
6,67E+01​
2,18E+00​
6,83E+01​
2,24E+00​
7,00E+01​
2,29E+00​
7,17E+01​
2,35E+00​
7,34E+01​
2,41E+00​
7,52E+01​
2,46E+00​
7,71E+01​
2,53E+00​
7,90E+01​
2,59E+00​
8,09E+01​
2,65E+00​
8,28E+01​
2,71E+00​
8,48E+01​
2,78E+00​
8,69E+01​
2,85E+00​
8,89E+01​
2,91E+00​
9,11E+01​
2,98E+00​
9,32E+01​
3,05E+00​
9,54E+01​
3,13E+00​
9,77E+01​
3,20E+00​
1,00E+02​
3,28E+00​
1,02E+02​
3,35E+00​
1,05E+02​
3,43E+00​
1,07E+02​
3,51E+00​
1,10E+02​
3,60E+00​
1,12E+02​
3,68E+00​
1,15E+02​
3,77E+00​
1,18E+02​
3,85E+00​
1,20E+02​
3,94E+00​
1,23E+02​
4,03E+00​
1,26E+02​
4,12E+00​
1,29E+02​
4,22E+00​
1,32E+02​
4,31E+00​
1,35E+02​
4,41E+00​
1,38E+02​
4,51E+00​
1,41E+02​
4,61E+00​
1,44E+02​
4,71E+00​
1,47E+02​
4,82E+00​
1,50E+02​
4,92E+00​
1,54E+02​
5,03E+00​
1,57E+02​
5,14E+00​
1,60E+02​
5,25E+00​
1,64E+02​
5,37E+00​
1,67E+02​
5,48E+00​
 

Excel Facts

When did Power Query debut in Excel?
Although it was an add-in in Excel 2010 & Excel 2013, Power Query became a part of Excel in 2016, in Data, Get & Transform Data.
Hi
thank you for your advice.that is working...is more fast then clicking..
what about vba? is that possible to write in vba code so it would be converted automaticly?
thank again
 
Upvote 0
Use the macro recorder to record the code.
Then optimize/clean the code.
 
Upvote 0
Hello
yes I just remember if I can do that with macro help
OK i will try if I will managed that
thank you
I will write again if I will be lost in strings
:oops:
 
Upvote 0

Forum statistics

Threads
1,215,201
Messages
6,123,621
Members
449,109
Latest member
Sebas8956

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top