![]() If you could turn it off, then the entered "date-like strings, number-like strings" would stay in text format with zero value, but they would be not converted to formatted numeric values, they still pure strings. There is "date/number recognition" feature. There is not any "date correction" feature in the AOO/LO Calc application. It sets the evaluation context for type conversions without changing existing values.Īll this to just admit that there is no simple way to turnoff the auto date correction. + (dot and plus), replace with & and hit Īfter you converted all strings to correct numbers, you can switch back to your preferred locale setting. with extra options "Regular Expressions" and "Current Selection" Select the cells in question, apply any number format that is not "Text" and call Data>Text To Columns., uncheck all delimiters and confirm the dialog.Ģ. With a wrong locale the conversion fails completely or you get wrong values.ġ. The locale setting is also crucial when you convert by means of formulas. US English for M/D/Y dates, German for point separated D.M.Y dates). This is pretty much the same as in Calc and older Excel verisions of the 90ies but Calc provides 2 additional options which allow you to do the conversion in place:Ĭall Tools>Options>LanguageSettings>Languages and adjust the "Locale" setting to the language of your text data (e.g. I guess we will have to wait some developer to write those two lines of code, as microsoft did when she forgot start menu for Windows 8 and put it back there in 10 when the need was there.ĭates in Excel and how to convert text to numbers by means of formulas: I understand that you will come back with another comment of the sort: it is the way it is, it is explained on the manual and there is a group of users that could disable it by mistake and the end of the world will come, so that is the reason there is no on-off. Making the feature go on and off is not hard to code. You just want a program for you and only for you (your need VS my need)Īs for my opinion that the auto-date feature is very useful, but not as useful as the option to turn it off (even if the default installation has it on). I understand that you fail to acknoledge that there are actually lots of other features in spreadsheets, that make those programs ideal to the other users because of their versatility (besides the date incovenience). You are actually right on the "since 1980" part (i checked on MS excel 2000), and I understand that with the term "non-users" you refer to all the other users of the world beside the ones that need the date-feature not only by default, but without on-off availability. Toggling either of those with dates, messes things up (i tried all combinations to test my point) Text to number switching has no effect on actual value if you change them either way. Actually there are three kinds of values, dates/time, numbers and text
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |