SOLVED

# A numeric cell without formulas when entering a range of 1-12 produces a date or 44531

Occasional Contributor

# A numeric cell without formulas when entering a range of 1-12 produces a date or 44531

Числовая ячейка без формул при вводе диапазона 1-12 выдает дату или 44531 как устранить эту проблему (ошибку)?

9 Replies

# Betreff: A numeric cell without formulas when entering a range of 1-12 produces a date or 44531

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.

Отмена автоматической замены чисел датами

https://support.microsoft.com/ru-ru/office/%d0%be%d1%82%d0%bc%d0%b5%d0%bd%d0%b0-%d0%b0%d0%b2%d1%82%d...

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)

best response confirmed by Vlad54k1 (Occasional Contributor)
Solution

# Re: A numeric cell without formulas when entering a range of 1-12 produces a date or 44531

@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".

# Re: A numeric cell without formulas when entering a range of 1-12 produces a date or 44531

@Riny_van_Eekelen большое спасибо за разъяснение

# Re: A numeric cell without formulas when entering a range of 1-12 produces a date or 44531

thanks a lot for the clarification

# Betreff: A numeric cell without formulas when entering a range of 1-12 produces a date or 44531

thanks a lot for the clarification

# Re: A numeric cell without formulas when entering a range of 1-12 produces a date or 44531

@Vlad54k1 Рад, что смог помочь

# Re: A numeric cell without formulas when entering a range of 1-12 produces a date or 44531

@Riny_van_Eekelen , you know Russian!

??

# Re: A numeric cell without formulas when entering a range of 1-12 produces a date or 44531

@Sergei Baklan Don't speak Russian, but Google does