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 Copy and Paste Only Values in Excel February 14, 2018 Removing Duplicates in Excel October 3, 2016 Excel text functions =left and =right October 3, 2016