| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
scientific notation to text formatting question
I have a string that looks like "92343E102".
When I assign it: Worksheet.Cells(outrow, 3) = strTest Excel converts the string to scientifc notation "9.23E+106" how do I presrve the string the way it is? Thanks |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Scientific Notation - Suppression of Auto-formatting | Excel Discussion (Misc queries) | |||
| Formatting as TEXT as opposed to scientific notation | Excel Discussion (Misc queries) | |||
| Number Formatting/Scientific notation | Excel Discussion (Misc queries) | |||
| Scientific notation in text cells | Excel Discussion (Misc queries) | |||
| Using scientific notation in TEXT() function | Excel Worksheet Functions | |||
Threaded Mode
