| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
change scientific notation (exponential) back to text
Hi.
I have received a file and some of the customer # has been changed as scientific notation. 8.50E+281 like so. I went format CellText and it doesn't convert back to text. I have also tried Text column text and it still remains the same. Is there a way to restore what it used to be? It's supposed to be 85E280. THANK YOU! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Change number format from text to number? | New Users to Excel | |||
| Using scientific notation in TEXT() function | Excel Worksheet Functions | |||
| Formulas dealing with text data | Excel Worksheet Functions | |||
| Removing Scientific Notation | New Users to Excel | |||
| change typed text to upper case | Excel Discussion (Misc queries) | |||
Threaded Mode
