| 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 |
| 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 | |||
Threaded Mode
