Numbers Stored as Text

[citadel_87]

Due a ton of work importing .CSV files and I am always fighting numbers stored as text. Suggestions? When you do lookups the error goes over to the results. I have multipled by one, converted to text, converted to value and used data text to columns...What a pain

 

[EducatedFool]

Select the range with numbers stored as text, and run the macro:

Sub Test()
    Application.ScreenUpdating = False
    Dim Cell As Range
    Selection.NumberFormat = "General"
    For Each Cell In Selection.Cells
        Cell.Value = Cell.Value
    Next
End Sub

 

[citadel_87]

I am not an expert, can you give me a qucik lesson on how to run your macro

 

[citadel_87]

Thanks I figured it out