Numbers Stored as Text

citadel_87

New Member
Joined
Jun 10, 2009
Messages
27
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
 

Some videos you may like

Excel Facts

Show numbers in thousands?
Use a custom number format of #,##0,K. Each comma after the final 0 will divide the displayed number by another thousand

EducatedFool

Active Member
Joined
Jun 10, 2009
Messages
272
Select the range with numbers stored as text, and run the macro:

Code:
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
 

Watch MrExcel Video

Forum statistics

Threads
1,118,852
Messages
5,574,662
Members
412,608
Latest member
Guromir
Top