Forum Discussion
Vlad54k1
Jan 28, 2021Copper Contributor
A numeric cell without formulas when entering a range of 1-12 produces a date or 44531
Числовая ячейка без формул при вводе диапазона 1-12 выдает дату или 44531 как устранить эту проблему (ошибку)?
- Jan 28, 2021
Vlad54k1 The number 44531 is the number that Excel uses for the date 1 December 2021. That is, day number 44531 counting from 1 January 1900. When you enter "1-12" (without the quotes) Excel interprets it as day 1 and month 12 in the current year (being 2021).
If you want to enter a text like "1-12" you can put an apostrophe in front or format the cells(s) as Text before you enter "1-12".
Vlad54k1
Jan 28, 2021Copper Contributor
Riny_van_Eekelen большое спасибо за разъяснение
Riny_van_Eekelen
Jan 28, 2021Platinum Contributor
Vlad54k1 Рад, что смог помочь
- SergeiBaklanJan 28, 2021Diamond Contributor
Riny_van_Eekelen , you know Russian!
- Riny_van_EekelenJan 29, 2021Platinum Contributor
SergeiBaklan Don't speak Russian, but Google does 🙂
- Vlad54k1Jan 29, 2021Copper Contributor??