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
|