| 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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
scientific notation to text formatting question
Set the format of the cell to text prior to assigning it a value.
For example, Worksheet.Cells(outrow, 3).NumberFormat = "@" Worksheet.Cells(outrow, 3) = strTest -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "dtdd" <dd@eer wrote in message ... 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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
scientific notation to text formatting question
Chip Pearson wrote:
Set the format of the cell to text prior to assigning it a value. For example, Worksheet.Cells(outrow, 3).NumberFormat = "@" Worksheet.Cells(outrow, 3) = strTest It solved the problem. Thanks |
| Reply |
| 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 | |||
Linear Mode
