Does it? I think it only affects when you enter the value, it doesn't change the... | Hacker News

Hacker News new | past | comments | ask | show | jobs | submit

login

		deepsun 9 days ago \| parent \| context \| favorite \| on: Cursed Excel: "1/2"+1=45660 Does it? I think it only affects when you enter the value, it doesn't change the underlying data that someone else stored in a doc.

mulmen 8 days ago [–]

I just tested it. The setting applies on data entry but opening a CSV or similar delimited file counts as “data entry”. So if you work strictly with xlsx files you are fine but it will irreversibly convert the values on open for delimited files unless you change the defaults.

Join us for AI Startup School this June 16-17 in San Francisco!
Guidelines | FAQ | Lists | API | Security | Legal | Apply to YC | Contact