•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Excel keeps converting "10-3242" to Oct-3242, no matter what I've tried so far
Our take
Are you frustrated with Excel's automatic date conversion? You're not alone. A user recently encountered this issue with the value "10-3242." Despite formatting the cell as "General" and using formulas to display it correctly, the value reverts to a date format upon reopening the file. This common challenge can disrupt your workflow and productivity. If you're seeking a solution, consider exploring alternative methods to preserve your intended formatting and prevent Excel from making unwanted changes. Let's dive into some effective strategies.
For some reason, excel keeps converting this value into a date format, no matter what I've tried, which is:
- '10-3242
- ="10-3242"
- Format cell > General
If I do the first two, it'll appear/display correctly, but if I close it and reopen after saving the file, it'll revert back to the date format.
Any ideas on what I can do?
[link] [comments]
Read on the original site
Open the publisher's page for the full experience
Tagged with
#Excel alternatives for data analysis#Excel compatibility#Excel alternatives#rows.com#natural language processing for spreadsheets#generative AI for data analysis#Excel#date format#conversion#10-3242#format cell#general#display#value#revert#save#close#ideas#cell#submitted