Pasting data - String with character "E" being treated as scientific

[Seeka]

Hi folks.
Haven't posted on here for a while but any help would be much appreciated.
I have thousands of rows of data to copy and paste into Excel that includes a column with serial numbers.
These numbers could contain any combination of numbers and letters but also occasionally other characters.
The problem I have is that some strings contain the letter "E" followed by numerical characters.
How would I get the following serial numbers to display correctly in excel?
64128
BPM20S-014379
TM12-01-220904623
CE428811
15E18446
B16091L0375
17326E00250
1719/17/CR

To take 17326E00250 as an example, depending on the formatting I get;
1.73E+254 (Scientific)
1.7326E+254 (Text)
173260000 +another 246 zeros (Number)

Many thanks

 

[ebea]

Try to look at this Youtube Video, which have a good explanation of prevent numbers with E inside, to change to scientific strings.

 

[Seeka]

Try to look at this Youtube Video, which have a good explanation of prevent numbers with E inside, to change to scientific strings.

Hi
Thank you for the response.
I've tried both of these methods but just seem to get results like these;

I'm dealing with .xlsx and .xls rather then .csv. Could that be why?
I tried changing the extension to .csv first but I still get the above result.
Jon

 

[Joe4]

You cannot convert an XLSX or XLS file to a CSV by changing its file extension (no more than you could change an Excel file to a Word file, PDF, or JPG by changing the file extension).
The file extension if just informational (gives you a clue as to what type of file it is). Changing the extension does not change the content of the file at all. You could give it a file extension of ".bob" and it still wouldn't change the content of the file.

The important question is where exactly is this data coming from?
Where are you copying it from?

 

[Seeka]

Hi Joe4, ebea
I'm copying and pasting it from an Analytics tool we use at work called Omniscope by Visokio.
Joe4 I think your reply may have nudged me in the right direction already.
I'd been copying and pasting from Omniscope but Omniscope does also have an option to export the data and you then get an option to save as a file type and you can select .csv
Using the steps from ebea's youtube recommendation above I can then import the saved data into my worksheet as a .csv file.
I think between your posts I may have found the solution I need.
Thank you both
Gratefully, Jon

 

[Joe4]

Excellent! Glad to hear it!
I marked your last post as the solution.