Hi
I have a web query which retrieves several columns of data. sometimes the data is in the following format like 28-06, or 04-20. When the data is inputted in to my spreadsheet it is written in date format, eg 28-June or April-20 respectively. I have tried pre-formatting cell before data input, I have tried separating data before and after (-) but nothing works. Hope someone can help.
Thank you in advance for taking the time for this.
I have a web query which retrieves several columns of data. sometimes the data is in the following format like 28-06, or 04-20. When the data is inputted in to my spreadsheet it is written in date format, eg 28-June or April-20 respectively. I have tried pre-formatting cell before data input, I have tried separating data before and after (-) but nothing works. Hope someone can help.
Thank you in advance for taking the time for this.
