Why is Excel vlookup diplaying date field as 0

February 19, 2018 at 02:16:41
Specs: Windows 7
When viewed within the formula dialogue window Excel shows the date number correctly separated by commas. But it returns a zero.

See More: Why is Excel vlookup diplaying date field as 0

Report •

#1
February 19, 2018 at 05:37:59
Without more info there isn't much we can do. Keep in mind that we can't see your workbook from where we're sitting, so we have no idea what your data looks like, what formula you are using, etc.

Perhaps some example data would help. Please click the How To link at the end of this post, read those instructions and then post a short example of your data along with the formula so we can try and see what is going on. Don't forget to include Column Letters and Row numbers.

The more detail you provide, the better the chance that we can help you.

How To Post Data or Code ---> Click Here Before Posting Data or VBA Code


Report •
Related Solutions


Ask Question