Scientific notation issue

[daveyc18]

so i open a text file , buit the issue is that when the macro does so, it obviously will open it in excel and what happens is that one of the cusips (eg 064151E58) gets automatically converted to scientific notation (6.42E+62 in this case)....is there anyway to prevent this?

or , perhaps, as a control, scan the column to see if the formatting is scientific notation, then alert the user that you'l

 

[RoryA]

Don't open it, import it. That will give you the chance to specify that the column type is Text.

 

[Fluff]

Use the import text wizard & then you can specify those columns should be text.

 

[daveyc18]

can the import be done via macro. ?

 

[Fluff]

Yes, just turn on the macro recorder & record yourself dong it manually & you 'll have the code.

 

[daveyc18]

what about the part of scanning cells if its scientific notiation format? just curious what the code would be or if its even possible

 

[Fluff]

You don't "scan" the cells, you just specify which columns need to be imported as text.

 

[daveyc18]

using the import wizard ...used office 365...oddly, it copies the data as a table