Jan 28 2021 05:21 AM
Числовая ячейка без формул при вводе диапазона 1-12 выдает дату или 44531 как устранить эту проблему (ошибку)?
Jan 28 2021 07:54 AM
I don't see a problem as far as I could understand, maybe the translation is also incorrect
Move the cells down and it will appear as it should. See file.
Here is additional information from Microsoft, maybe this will help you.
Отмена автоматической замены чисел датами
I would be happy to know if I could help.
I wish you continued success with Excel
Nikolino
I know I don't know anything (Socrates)
Jan 28 2021 09:01 AM - edited Jan 28 2021 09:04 AM
Solution@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".
Jan 28 2021 09:11 AM
@Riny_van_Eekelen большое спасибо за разъяснение
Jan 28 2021 09:12 AM
Jan 28 2021 09:13 AM
Jan 28 2021 09:13 AM
@Vlad54k1 Рад, что смог помочь
Jan 28 2021 11:59 AM
@Riny_van_Eekelen , you know Russian!
Jan 28 2021 07:50 PM
Jan 28 2021 09:19 PM
@Sergei Baklan Don't speak Russian, but Google does :)
Jan 28 2021 09:01 AM - edited Jan 28 2021 09:04 AM
Solution@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".