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.

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

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

@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