SOLVED

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

%3CLINGO-SUB%20id%3D%22lingo-sub-2106017%22%20slang%3D%22en-US%22%3EA%20numeric%20cell%20without%20formulas%20when%20entering%20a%20range%20of%201-12%20produces%20a%20date%20or%2044531%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2106017%22%20slang%3D%22en-US%22%3E%3CP%3E%D0%A7%D0%B8%D1%81%D0%BB%D0%BE%D0%B2%D0%B0%D1%8F%20%D1%8F%D1%87%D0%B5%D0%B9%D0%BA%D0%B0%20%D0%B1%D0%B5%D0%B7%20%D1%84%D0%BE%D1%80%D0%BC%D1%83%D0%BB%20%D0%BF%D1%80%D0%B8%20%D0%B2%D0%B2%D0%BE%D0%B4%D0%B5%20%D0%B4%D0%B8%D0%B0%D0%BF%D0%B0%D0%B7%D0%BE%D0%BD%D0%B0%201-12%20%D0%B2%D1%8B%D0%B4%D0%B0%D0%B5%D1%82%20%D0%B4%D0%B0%D1%82%D1%83%20%D0%B8%D0%BB%D0%B8%2044531%20%D0%BA%D0%B0%D0%BA%20%D1%83%D1%81%D1%82%D1%80%D0%B0%D0%BD%D0%B8%D1%82%D1%8C%20%D1%8D%D1%82%D1%83%20%D0%BF%D1%80%D0%BE%D0%B1%D0%BB%D0%B5%D0%BC%D1%83%20(%D0%BE%D1%88%D0%B8%D0%B1%D0%BA%D1%83)%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2106017%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2106669%22%20slang%3D%22de-DE%22%3ESubject%3A%20A%20numeric%20cell%20without%20formulas%20when%20entering%20a%20range%20of%201-12%20produces%20a%20date%20or%2044531%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2106669%22%20slang%3D%22de-DE%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F946086%22%20target%3D%22_blank%22%3E%40Vlad54k1%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22VIiyi%22%3E%3CSPAN%20class%3D%22JLqJ4b%20ChMk0b%22%3E%3CSPAN%3EI%20don't%20see%20a%20problem%20as%20far%20as%20I%20could%20understand%2C%20maybe%20the%20translation%20is%20incorrect%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22VIiyi%22%3E%3CSPAN%20class%3D%22JLqJ4b%20ChMk0b%22%3E%3CSPAN%3EMove%20the%20cells%20down%20and%20it%20will%20appear%20as%20it%20should.%3C%2FSPAN%3E%3C%2FSPAN%3E%20%3CSPAN%20class%3D%22JLqJ4b%20ChMk0b%22%3E%3CSPAN%3ESee%20file.%3C%2FSPAN%3E%3C%2FSPAN%3E%20%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22VIiyi%22%3E%3CSPAN%20class%3D%22JLqJ4b%20ChMk0b%22%3E%3CSPAN%3EHere%20is%20additional%20information%20from%20Microsoft%2C%20maybe%20this%20will%20help%20you.%3C%2FSPAN%3E%3C%2FSPAN%3E%20%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%D0%9E%D1%82%D0%BC%D0%B5%D0%BD%D0%B0%20%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%20%D0%B7%D0%B0%D0%BC%D0%B5%D0%BD%D1%8B%20%D1%87%D0%B8%D1%81%D0%B5%D0%BB%20%D0%B4%D0%B0%D1%82%D0%B0%D0%BC%D0%B8%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fsupport.microsoft.com%2Fru-ru%2Foffice%2F%25d0%25be%25d1%2582%25d0%25bc%25d0%25b5%25d0%25bd%25d0%25b0-%25d0%25b0%25d0%25b2%25d1%2582%25d0%25be%25d0%25bc%25d0%25b0%25d1%2582%25d0%25b8%25d1%2587%25d0%25b5%25d1%2581%25d0%25ba%25d0%25be%25d0%25b9-%25d0%25b7%25d0%25b0%25d0%25bc%25d0%25b5%25d0%25bd%25d1%258b-%25d1%2587%25d0%25b8%25d1%2581%25d0%25b5%25d0%25bb-%25d0%25b4%25d0%25b0%25d1%2582%25d0%25b0%25d0%25bc%25d0%25b8-452bd2db-cc96-47d1-81e4-72cec11c4ed8%3Fui%3Dru-RU%26amp%3Brs%3Dru-RU%26amp%3Bad%3DRU%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3Ehttps%3A%2F%2Fsupport.microsoft.com%2Fru-ru%2Foffice%2F%25d0%25be%25d1%2582%25d0%25bc%25d0%25b5%25d0%25bd%25d0%25b0-%25d0%25b0%25d0%25b2%25d1%2582%25d0%25be%25d0%25bc%25d0%25b0%25d1%2582%25d0%25b8%25d1%2587%25d0%25b5%25d1%2581%25d0%25ba%25d0%25be%25d0%25b9-%25d0%25b7%25d0%25b0%25d0%25bc%25d0%25b5%25d0%25bd%25d1%258b-%25d1%2587%25d0%25b8%25d1%2581%25d0%25b5%25d0%25bb-%25d0%25b4%25d0%25b0%25d1%2582%25d0%25b0%25d0%25bc%25d0%25b8-452bd2db-cc96-47d1-81e4-72cec11c4ed8%3Fui%3Dru-RU%26amp%3Brs%3Dru-RU%26amp%3Bad%3DRU%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20would%20be%20happy%20to%20know%20if%20I%20could%20help.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20wish%20you%20continued%20success%20with%20Excel%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ENikolino%3C%2FP%3E%3CP%3EI%20know%20I%20don't%20know%20anything%20(Socrates)%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Contributor

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

9 Replies

@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%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

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

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