This free Excel macro formats a selected cell or range of cells to the General number format in Excel. This is the default number format and contains no special or specific formatting.
This is a great macro when you need to remove special number formatting from a large selection of cells quickly. This macro allows you to see exactly what is entered into the cell in Excel instead of a pre-formatted value.
Sub Format_Cell_General()
Selection.NumberFormat = "General"
End Sub