Oct 07 2019 02:49 PM
I'm looking for dates in an Excel report to match dates downloaded from a web report and subsequently, bring back a value several rows over. A typical Vlookup function. I've tried formatting both columns of dates the same, but no matter what I've tried, the dates in the Excel report don't match the dates from the web and I get #N/A as a result. Can you help?
Oct 07 2019 04:06 PM
Hi @markjoyus ,
What type of formatting did you choose for both the columns? It may help to:
Alternatively,
Hope this helps.
Oct 07 2019 04:59 PM
I can work with the data (dates) in the web report, but the data that is sent to me as a .xls file will not budge when I try to change the formatting.
Oct 07 2019 05:06 PM
How about resaving that file and choose specifically the .xlsx format? @markjoyus
Oct 08 2019 07:00 AM
SolutionI tried saving as a .xlsm, a .xlsx and it didn't make any difference. However! I saved as a .txt and was able to copy and paste over the dates.
Thanks for your input!
Feb 01 2021 12:20 AM
Oct 08 2019 07:00 AM
SolutionI tried saving as a .xlsm, a .xlsx and it didn't make any difference. However! I saved as a .txt and was able to copy and paste over the dates.
Thanks for your input!