How to make Excel save numbers and not dates?

Question

excel

Hi all. I use the .csv format, change the format of the fields to "text". Everything is OK, I save, close, re-open and Excel does it its own way again (the dates are already written). How to defeat him already?

Answer 1

For decimals in excel, a comma is used, not a period.
If you use a dot, then you get dates. Hence all the troubles.
You can win in several ways of varying degrees of curvature.
1) Save not in csv, but in the format of Excel itself, and only save the final version in csv.
2) Add any symbol (for example, x) before the number. It will turn out x1.1, or add something to the end. This will make the value a string with no options.
3) The saved csv is parsed every time by the script after saving to replace the dates with the corresponding numbers. The script can be written quite quickly, any programmer can do it in a maximum of half an hour.

Answer 2

One option is to add an apostrophe " ' " before the number, Excel sees it and does not display it.
But when you save to csv, most likely it will save it too, and your csv may not be correct. Need to try.

Answer 3

Or another crutch option: in the settings, change the default decimal separator to a dot.