Hello,
I have a spreadsheet (from a pdf conversion), where the date is specified as JUN01, as example and I want it to show as 06-01-2017. I am trying the text formula TEXT(D3, "mm-dd-yyy") but it returns the current year and I need to use an older year. I am then importing the data so the fact that it is not a date format is not that important.
Any suggestions?
I have a spreadsheet (from a pdf conversion), where the date is specified as JUN01, as example and I want it to show as 06-01-2017. I am trying the text formula TEXT(D3, "mm-dd-yyy") but it returns the current year and I need to use an older year. I am then importing the data so the fact that it is not a date format is not that important.
Any suggestions?