| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| csv with 12 number column & opens as scientific formula | Excel Discussion (Misc queries) | |||
| Change number format from text to number? | New Users to Excel | |||
| Change number to text formula | Excel Worksheet Functions | |||
| not able to convert text, or graphic number to regular number in e | Excel Worksheet Functions | |||
| EZ Q 4 U: How do I change a number to text, based on the number | Excel Worksheet Functions | |||
Linear Mode
