The following formula will give you a real Excel date -- format it any way you like:Hello, I am needing to do just the opposite. I need to change text 20170101 to reflect 01/01/2017. Any help would be greatly appreciated! Thanks
The following formula will give you a real Excel date -- format it any way you like:
=--TEXT(--A1,"#-00-00")