Change Scientific Notation from selected column

[mictlantecuhtli]

Hi guys, I have another question for you,

I have an excel file, and on one of the file columns I have these numbers, some are in number format but it has some scientific, I need a macro to run on the selected column and convert scientific to text

Thank's in advanced

Greetings from México

 

[SpillerBD]

The cells should be formatted as TEXT to begin with.
If importing such data from an external file, you can use the legacy import wizard and make sure the Data is brought in as Text.

If, as it sounds you have the data already in Excel, you can convert "numbers" to text using the Text to Columns tool, found on the DATA Ribbon, built in and select Text in the Third Window

 

[mictlantecuhtli]

Ok, there's no way to do it with VBA

Thank's

 

[SpillerBD]

If it is always the same column, just record the steps of Text-to-Columns for that column.
If it changes columns, the macro will have to be changed for Selected Column and First Row of selected Column, for destination.
However, this should be a one-and-done process. If there is a data entry issue, it is that the cells are left to be GENERAL before data entry. Excel is not a Database, but when attempted to use as such, the database principle of assigning the data type for a field MUST be followed.
If the Data is being imported, the Import method needs to be corrected or a different method all together should be used.

 

[SpillerBD]

Say for example, Column E is the column to "fix", the VBA code would be:

Sub TTC_TEXT_COL_E()
    Columns("E:E").Select
    Selection.TextToColumns Destination:=Range("E1"), DataType:=xlDelimited, _
        TextQualifier:=xlDoubleQuote, ConsecutiveDelimiter:=False, Tab:=False, _
        Semicolon:=False, Comma:=False, Space:=False, Other:=False, FieldInfo _
        :=Array(1, 2), TrailingMinusNumbers:=True
End Sub