Forum Discussion

Vlad54k1's avatar
Vlad54k1
Copper Contributor
Jan 28, 2021
Solved

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

Числовая ячейка без формул при вводе диапазона 1-12 выдает дату или 44531 как устранить эту проблему (ошибку)?
Formulas and Functions
office 365
  • Riny_van_Eekelen's avatar
    Riny_van_Eekelen
    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".

NikolinoDE's avatar
NikolinoDE
Platinum Contributor
Jan 28, 2021

Vlad54k1 

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%d0%be%d0%bc%d0%b0%d1%82%d0%b8%d1%87%d0%b5%d1%81%d0%ba%d0%be%d0%b9-%d0%b7%d0%b0%d0%bc%d0%b5%d0%bd%d1%8b-%d1%87%d0%b8%d1%81%d0%b5%d0%bb-%d0%b4%d0%b0%d1%82%d0%b0%d0%bc%d0%b8-452bd2db-cc96-47d1-81e4-72cec11c4ed8?ui=ru-RU&rs=ru-RU&ad=RU

 

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)

 

  • Vlad54k1's avatar
    Vlad54k1
    Copper Contributor
    Jan 28, 2021
    thanks a lot for the clarification

Resources