I have three questions relating to using web query on MacOS 16.65.
I am using web query to draw in data from the internet and populate into the below sheet. Any formatting changes I make to this data are reverted once I refresh to get the latest external data.
- Is is possible to avoid this through use of VBA or otherwise and if so, what code / formula is suggested?
Some of the dates that are brought in from the web are formatted as text and some as dates.
- Is it possible to automatically change these text formatted cells to date format upon import?
The cells that are already date formatted are using the US format MM/DD/YYYY and when I am trying to use VLOOKUP to look for dates in the DD/MM/YYYY I get an N/A return or incorrect data.
- How can I achieve
VLOOKUPfinding the correct data?
