Forum Discussion
retaining text format
Hi, I have this problem when I scrap data in the format of XXXX-XX-XX but when I open the Excel file it turns into a date format as follows: How do I keep the original format I scrapped? Than...
I wasn't able to find Automatic Data Conversion in Advanced Options, yet any changes to my date entries automatically converted. However, the very bottom of Advanced Options has two boxes for Lotus compatibility settings. They were checked. I unchecked them and the problem was resolved.
preceding each value with an apostrophe.
e.g.
'2023-06-07
e.g.
'2023-06-07
