Correct Scientific copied numbers

[JTL9161]

I run a macro to screen scrape data from our companies database (IBM-PComm)

Some of the data contains numbers and a letter, for example 30E82. This number though is copied into my spreadsheet as scientific format and shows like this 3.00E+92. When I try to re-format it to a number it then shows

<colgroup><col width="696"></colgroup><tbody>
[TD="class: xl142, width: 696"]300000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000.00[/TD]

</tbody>

Is there a way to get this to either copy from our database as 30E82 or a way to convert it?


Thank you,
James

 

[joeu2004]

Presumably the data comes from a text file (perhaps CSV). You need to treat the data as text. It would be helpful if you posted the VBA code, at least the part that reads the data and stores it into an Excel cell. But the latter should look something like this.

Dim s As String
.... input into s ....
Range("A1").NumberFormat = "@"    ' Format as Text
Range("A1").Value2 = s