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...
(ignore "s)
"1/1/2024" becomes "=1/1/2024". The former resolves to 45292, while the latter resolves to 0.000494071146245059. Is that not ADC?
rhoneyman If that happens and you don't have the feature I described, you'll have to live with it and properly import data via the legacy text wizard or preferable Power Query.