Thread: scientific notation to text formatting question
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Chip Pearson Chip Pearson is offline
external usenet poster
  
Posts: 7,247
Default 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


Reply With QuoteReply With Quote