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

Can a formula spear through sheets?
Use =SUM(January:December!E7) to sum E7 on all of the sheets from January through December
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,992
Messages
6,128,165
Members
449,428
Latest member
d4vew

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