BUY EXCEL BOOKS ONLINE: 1. VBA & Macros      2. VBA for Modelers      3. Excel 2013 VBA and Macros     
4. Excel VBA for Dummies      5. Excel with VBA & .NET      6. Mastering VBA      7. Excel 2013 Programming

Convert Numbers appearing as Text to their Values (Number Format) (Remove Green Sign)

    Sub Convert_Textual_Numbers_to_Values()
        'This module will convert numbers appearing as text (Green marked) to their respective values in Number format.
        Dim MyCell As Range
        For Each MyCell In Selection.Cells
            MyCell.NumberFormat = "0"
            MyCell.Value = Val(Trim(MyCell.Value))
        Next
    End Sub