在Excel单元格中插入日期

I am trying to insert the current date in a cell (with standard format). When I write the shortcut "ctrl + ;" the date is written correctly in the the cell, but when I quit the cell, the value is automatically replaced with #####, I don't understand why.

我试图在一个单元格中插入当前日期(标准格式)。当我写快捷方式“ctrl +;”日期在单元格中正确写入,但是当我退出单元格时,该值会自动替换为#####,我不明白为什么。

Thanks in advance for your help.

在此先感谢您的帮助。

1 个解决方案

#1

It was just a problem of column width.

这只是列宽的问题。