•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Why does excel convert numbers into dates even when explicitly turning it off?
Our take
Excel's tendency to convert numbers into dates, even when users have disabled this feature, can be frustrating and disruptive. This behavior stems from Excel's underlying design, which prioritizes interpreting input data to enhance usability. However, this can lead to unintended consequences, particularly when users explicitly want to maintain their original data formats. Understanding why this happens is crucial for users who rely on accurate data representation. By exploring the mechanics behind this conversion, we can better navigate Excel's complexities and protect our valuable information.
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?
[link] [comments]
Read on the original site
Open the publisher's page for the full experience
Related Articles
- Excel keeps converting "10-3242" to Oct-3242, no matter what I've tried so farFor 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? submitted by /u/GreenGloober [link] [comments]
- Unify excel date format for all usersAt work we have a file, that used to be set up in a way, where no matter what date format you use (dd.mm.yy ; mm.dd.yy ; d.m.yy ; m.d.yy ; dd/mm/yyyy ; dd/mm/yy ; ...) it would always visually adjust to the current users system settings and always read the input as date. So if one coworker used and typed dd/mm/yyyy, he would see all dates in the table like that. While I use dd.mm.yy and I would see all date like that. I hope the explanation makes sense... this stopped working last year, and I tried what internet suggested: Changing the user settings in OS to a format they use. Changing it to a adjustable format so everyone has their own format and now it is all set to a firm format (dd.mm.yy) so it displays the same for everyone and it doesn’t matter if they type it with slashes (dd/mm/yy ; dd/mm/yyyy) but if someone types specifically in dd.mm.yyyy format it doesnt recognize it as a date anymore... I feel insane at this point! submitted by /u/Expert_Plankton_7561 [link] [comments]
- Stop using Adobe Acrobat to convert PDFs to Excel. Here's why it corrupts your data and what to do instead.If you've ever exported a PDF to Excel using Acrobat and found that values like 75-01-04 turned into dates (serial number 63923), you're not alone. This happens because Acrobat interprets anything that looks like a date format during export, and the damage is done before Excel even opens the file. Here's what actually works: Option 1: Export as CSV, not XLSX. Acrobat preserves raw strings in CSV. Then import into Excel with all columns set to Text before it auto-formats. Option 2: Power Query. Data > Get Data > From File > From PDF. You can set column types to Text during import, which prevents the date conversion. Option 3: AI-based extraction tools. These read the document visually and extract text as-is — no date conversion because they treat everything as the text printed on the page. Useful for scanned PDFs where Power Query returns empty. If you're dealing with this regularly, here's a walkthrough of the different approaches: https://parsli.co/guides/extract-data-pdf-to-excel What methods are you all using? Curious if anyone's found a reliable Acrobat setting I'm missing. submitted by /u/No-Reindeer-9968 [link] [comments]
- How to stop Excel from changing decimals to scientific notation?I just got a new work laptop which uses Microsoft Office 365. I regularly pull in stock prices and currency foreign exchange conversion from Yahoo! Finance into CSV, which I then copy and paste values into my Excel spreadsheet. One of the items I pull from Yahoo! Finance is IDRSGD=X, which is basically converting Indonesian Rupiah (IDR) to Singapore Dollars (SGD). Now, say IDR 1 = SGD 0.000077 and it is shown as such in Yahoo! Finance. However, in the CSV, the number automatically becomes 7.7E-5. When I copied and pasted from the CSV to my Excel file, it stayed the same way, ie. 7.7E-5. I know they mean the same thing but it's ugly and it just stands out like a sore thumb against all my other data in my spreadsheet, which are nicely presented in decimals. How can I stop Excel from automatically converting this notation? I went to Options --> Data and unchecked the relevant boxes, but it didn't help. In Excel, even if I Format Cells --> Number to reflect decimals, it does not help either. Somehow the ugly scientific notation overrides the cell formatting. There are many cells in the data set showing scientific notation instead of decimals, and I cannot be going cell by cell. I never faced this problem with my previous Microsoft Office 2019. Can someone please help? submitted by /u/Traditional_Bell7883 [link] [comments]
Tagged with
#Excel alternatives for data analysis#Excel compatibility#Excel alternatives#big data management in spreadsheets#generative AI for data analysis#conversational data analysis#real-time data collaboration#intelligent data visualization#data visualization tools#enterprise data management#big data performance#data analysis tools#data cleaning solutions#rows.com#excel#date conversion#numbers#data#data integrity#options