Excel DATEVALUE Post author:Author Post published:October 3, 2016 Post category:Excel Tips Some data from other programs can come in as text instead of dates. Use the command DateValue to change text to a date. For more ways to make Excel work for you, take a training course from AdvantEdge Training & Consulting! You Might Also Like Excel Boot Camp – Become a Master of Excel April 17, 2018 Use Control + Y to repeat an action in Excel October 3, 2016 Make large numbers more readable in Excel October 5, 2016