•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
Related Articles
- How do I stop Excel from automatically changing decimals displayed.i.e. Let's say I want to type in the following data: 1 1.0 1.00 1.000 Excel will display: 1 1 1 1 But we want the sheet to reflect the precision of the numbers we've entered. I've tried messing with some of the advanced file options without any luck. Is the only way to do this to format all those cells as text or to manually change the decimals displayed for every entry? Edit: Actually, entering as text will fix how the data we enter is displayed but if it is used in any formulas we'll have the same issue with the results. i.e. If we multiply every one of those numbers by 4 then the results column will all display '4' with no decimals and I can't find a way to get it to maintain the precision of the input data. submitted by /u/IceCreamforLunch [link] [comments]
- Why does excel convert numbers into dates even when explicitly turning it off?Even when you turn off date conversion in options-data excel still insists on doing this, destroying the data. Why? Why would anyone think people explicitly turning it off would like this to continue? submitted by /u/Leverpostei414 [link] [comments]
- Excel keeps converting my product codes with E to scientific notation. How do I stop this permanently?I have a column of product codes that include letters and numbers, like 4E75, 2E100, 8E22. Every time I paste new data into this column, Excel automatically converts these codes into scientific notation (4E+75, 2E+100, etc.) and I lose the original text format. I have tried formatting the column as Text before pasting. I have also tried using the import wizard and setting the column as Text there. The problem happens again every time I open a new CSV or paste from another source. Is there a way to tell Excel to never interpret E as scientific notation globally or at least for a specific workbook? I am using Excel 365 on Windows. I know about the option to disable automatic data conversion in File > Options > Data, but I want to know if that actually works reliably for other people before I change it. submitted by /u/dududududuuim [link] [comments]
- Excel changing my input to random number or dateHey guys i am working on a Excel document with cas numbers of chemicals, if i put in the cas number 7789-02-8 excel changes it to 2150954 ( field is set to number ) if i set the field to standard it changes into a date. Why ? and does someone has a fix ? Edit: Microsoft Office LTSC Professional Plus 2024 Microsoft® Excel® LTSC MSO (Version 2408 Build 16.0.17932.20700) 64 Bit submitted by /u/Sir_Tafuu [link] [comments]
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