Forum Discussion
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 the output column and the input column but to no avail, could some one shed any light on it for me
=IFERROR(VLOOKUP($A26,'Deployment Schedule'!$A:$BG,6,FALSE),"")
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 the output column and the input column but to no avail, could some one shed any light on it for me
=IFERROR(VLOOKUP($A26,'Deployment Schedule'!$A:$BG,6,FALSE),"")
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.
Please help fix my date issue. If I put 5-24-18 or 5/24/18 it shows as 43244. The only way it is recognized as a date is if I put 5.24.18. It is even formatted as a date. Any help is greatly appreciated.
