Formula to change scientific number to regular number or text
 

"Hi I have a very large column with scientifc numbers that I would like to
change them to a regular number or text.
I don't want to change them manually one by one. Is there any formula to do
that. See example below
column A is the scientific number and I want regular number or text in
column A."
Thank you very much for your help

Scientific Text
2.80E+46 28E45
9.60E+104 96E103
5.50E+252 55E251
3.30E+221 33E220

Formula to change scientific number to regular number or text
 

See if this is what you're looking for:

=LEFT(TEXT(A1,"0.00E+00"),FIND("E",TEXT(A1,"0.00E+ 00"))-1)*10&"E"&MID(TEXT(A1,"0.00E+00"),FIND("+",TEXT(A1 ,"0.00E+00"))+1,99)-1

HTH,
Elkar


"Compare Values" wrote:

"Hi I have a very large column with scientifc numbers that I would like to
change them to a regular number or text.
I don't want to change them manually one by one. Is there any formula to do
that. See example below
column A is the scientific number and I want regular number or text in
column A."
Thank you very much for your help

Scientific Text
2.80E+46 28E45
9.60E+104 96E103
5.50E+252 55E251
3.30E+221 33E220

Formula to change scientific number to regular number or text
 

Yes, Thank you so much.

"Elkar" wrote:

See if this is what you're looking for:

=LEFT(TEXT(A1,"0.00E+00"),FIND("E",TEXT(A1,"0.00E+ 00"))-1)*10&"E"&MID(TEXT(A1,"0.00E+00"),FIND("+",TEXT(A1 ,"0.00E+00"))+1,99)-1

HTH,
Elkar


"Compare Values" wrote:

"Hi I have a very large column with scientifc numbers that I would like to
change them to a regular number or text.
I don't want to change them manually one by one. Is there any formula to do
that. See example below
column A is the scientific number and I want regular number or text in
column A."
Thank you very much for your help

Scientific Text
2.80E+46 28E45
9.60E+104 96E103
5.50E+252 55E251
3.30E+221 33E220