Forum Discussion
Mick Young
May 28, 2018Copper Contributor
Date showing as a number string
Morning guys, I am having trouble with a vlookup, when I use the vlookup below the date comes through as a string of numbers like so 43543, I have tried formatting the column to show date in both t...
SergeiBaklan
May 28, 2018MVP
Hi Mike,
If formula returns the number 43543 that is March 19, 2019 if you format that cell as date. Or it returns you the text '43543 ? You may check with ISTEXT() if you are not sure.