"Why does Excel automatically convert a numeric value with a dot into a datetime format? For instance, when I input '39.', it changes to '39.00.00,' which corresponds to '01/01/1900 15:00:00'."

Question

"Why does Excel automatically convert a numeric value with a dot into a datetime format? For instance, when I input '39.', it changes to '39.00.00,' which corresponds to '01/01/1900 15:00:00'."

Anonymous

When I input '39.', it changes to '39.00.00,' which corresponds to '01/01/1900 15:00:00'."

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

2 answers

Answer 1

Hello Galeth A, thanks for coming into forums. I'm Myk, an Independent Advisor and I'll be more than happy to help you.

As Palcouk mentioned, you may right click on the cell where you're entering the numeric value. After the right click, go to "Format Cells" option, then choose the "Category" that fits the corresponding entered value. (General, Number, Currency, Percentage, etc...) > Click OK afterwards to apply it in the cell.

If you require any further information, then please don’t hesitate to get in contact. I will be more than happy to assist you further.

Kind Regards, Myk

Answer 2

Anonymous

Depends on the cell format as to what is shown - rt click the Cell > Format

0 comments

Share via

"Why does Excel automatically convert a numeric value with a dot into a datetime format? For instance, when I input '39.', it changes to '39.00.00,' which corresponds to '01/01/1900 15:00:00'."

2 answers