VBA: Convert Text to Number

by

Use the below function (changing [E:E] to the appropriate range for your needs) to circumvent this issue (or change to any other format such as “mm/dd/yyyy”): 

[E:E].Select
With Selection
    .NumberFormat = "General"
    .Value = .Value
End With

P.S. In my experience, this VBA solution works SIGNIFICANTLY faster on large data sets and is less likely to crash Excel than using the ‘warning box’ method.

More Related Contents:

  1. SumIf using Excel VBA
  2. How can I call a macro which contains a loop but only run one iteration of that loop?
  3. Test or check if sheet exists
  4. How can I find last row that contains data in a specific column?
  5. Copy from one workbook and paste into another
  6. How to copy Outlook mail message into excel using VBA or Macros
  7. Open Excel file for reading with VBA without display
  8. For Loop not fully cycling in excel VBA [duplicate]
  9. Unique Random Numbers using VBA
  10. Populate unique values into a VBA array from Excel
  11. Excel VBA App stops spontaneously with message “Code execution has been halted”
  12. How to remove all non alphanumeric characters from a string except period and space in excel?
  13. Save each sheet in a workbook to separate CSV files
  14. Is VBA an OOP language, and does it support polymorphism?
  15. Export each sheet to a separate csv file
  16. What are .NumberFormat Options In Excel VBA?
  17. Excel: How to check if a cell is empty with VBA? [duplicate]
  18. Detect if range is empty
  19. Checking if a worksheet-based checkbox is checked
  20. Faster way to remove ‘extra’ spaces (more than 1) from a large range of cells using VBA for Excel
  21. Extract Data from Word Document to an Excel SpreadSheet
  22. Excel macro -Split comma separated entries to new rows [duplicate]
  23. VBA equivalent to Excel’s mod function
  24. Pointers needed for speeding up nested loop macro in VBA
  25. VBA editor auto-deletes spaces at the ends of lines
  26. ‘1004’: “The sort reference is not valid.”
  27. Select entire column in table using Excel VBA
  28. Reducing WithEvent declarations and subs with VBA and ActiveX
  29. How to protect Excel workbook using VBA?
  30. How to get the range of the visible rows after applying an advanced filter in Excel (VBA)

Leave a Comment