Ask Your Question

Why does the date format change when I overwrite a cell?

asked 2019-09-05 21:53:24 +0100

Rickdeckard2049 gravatar image

I am using and have a spreadsheet where one cell is in the date format MM/DD/YY. If I enter a new value, it displays correctly (eg. 09/05/19), but if I overwrite it, it displays as 09/05/2019. Why is it doing that?

edit retag flag offensive close merge delete


Do you mean going to cell edit mode (double click into the cell, to change a value) by using the term overwrite ?

Opaque gravatar imageOpaque ( 2019-09-05 22:18:03 +0100 )edit

3 Answers

Sort by » oldest newest most voted

answered 2019-09-05 22:37:17 +0100

Opaque gravatar image

updated 2019-09-05 22:44:35 +0100


the format doesn't change at all. You'll notice, that after you have finished your edit, that the date will display as per your format immediately after you've left the cell edit mode by having pressed ENTER. You need to understand that neither a value 'MM/DD/YY' nor 'MM/DD/YYYY' (or anything else) is stored in the cell, but an integer number. Your format definition in no way determines what is being stored. It only determines how it is displayed. Play around with various formats and change them to numbers, and you'll see what I mean. And in edit mode a data presentation, which fits to your localization, is being chosen for the input.

The format definition also in no way determines how your input will be interpreted (which means how it is converted to a number). This is solely determined by your localization settings. Try and format DD/MM/YY and enter in MM/DD/YYYY and you'll get confused.

edit flag offensive delete link more


the format doesn't change at all

Yes it did in the case of the bug I mentioned.

erAck gravatar imageerAck ( 2019-09-06 21:19:11 +0100 )edit

answered 2019-09-06 21:16:15 +0100

erAck gravatar image

Probably tdf#126116 which is fixed for 6.2.6.

edit flag offensive delete link more

answered 2019-09-05 22:24:29 +0100

Rickdeckard2049 gravatar image

Yes. I enter a new value in the cell and the format changes.

edit flag offensive delete link more


Please do not use Answer on this site, if you actually don't answer a question but responding to a comment. Use add a comment for that purpose or edit your original question to add more detailed information. Thanks in advance ...

Opaque gravatar imageOpaque ( 2019-09-05 22:34:56 +0100 )edit
Login/Signup to Answer

Question Tools

1 follower


Asked: 2019-09-05 21:53:24 +0100

Seen: 35 times

Last updated: Sep 06