Convert Text to Date?

by

You can use DateValue to convert your string to a date in this instance

Dim c As Range
For Each c In ActiveSheet.UsedRange.columns("A").Cells
    c.Value = DateValue(c.Value)
Next c

It can convert yyyy-mm-dd format string directly into a native Excel date value.

More Related Contents:

  1. How do you change the value of a cell in excel by clicking on it using VBA? [closed]
  2. excel vba compare & copy worksheets from 2 excel files
  3. How to avoid using Select in Excel VBA
  4. How to return a result from a VBA function
  5. Cycle through sub-folders and files in a user-specified root directory [duplicate]
  6. Using VBA in Excel to Google Search in IE and return the hyperlink of the first result
  7. VBA Shell function in Office 2011 for Mac
  8. How to merge rows in a column into one cell in excel?
  9. How to copy sheets to another workbook using vba?
  10. Check if value exists in column in VBA
  11. Excel vba refresh wait
  12. hiding formulas in formula bar
  13. How to delete multiple rows without a loop in Excel VBA
  14. Excel vba to create every possible combination of a Range
  15. VBA Many buttons point to the same _Click sub
  16. Run a Macro from Another Workbook
  17. Sorting a dictionary by key in VBA
  18. Handle “No cells were found” error when filtered range is empty
  19. VBA paste as values – how to
  20. Excel: the Incredible Shrinking and Expanding Controls [closed]
  21. What are the benefits of using Classes in VBA? [closed]
  22. Writing a VLOOKUP function in vba
  23. Generate Word Documents (in Excel VBA) from a series of Document Templates
  24. Handle cancellation of InputBox to select range
  25. Using Excel VBA Macro To Capture + Save Screenshot of Specific Area In Same File
  26. Type Mismatch in Loop to scan Outlook Messages [duplicate]
  27. VBA: How to combine two ranges on different sheets into one, to loop through
  28. Access files with long paths (over 260)
  29. Concatenate multiple ranges using vba
  30. How to highlight selected text within excel

Leave a Comment