At 13:53 28/08/2022 -0400, Vince Bonly wrote:
I now know why and how to correct this error. I found that when entering the starting date in cell A4, if I initially enter 02/23/2022, rather than 23 February 2022, the result in cell H4 is correct; e.g., 186.
So your new typing has been interpreted correctly as a date. But I'm surprised by the suggestion that your earlier version wasn't: if I enter "23 February 2022", it too is correctly interpreted as a date. I find it difficult to confuse the program. The only ways I see to end up with a text value is to format the cell as Text before typing or to paste in an existing text value.
In the future I must pay closer attention and utilize the correct method when wanting to type a date value within a cell.
But there is not just one correct method.
I also must remember that the cell format is only controlling what is displayed on screen.
Things are more complicated than that. Cell format affects how typing into the cell is *interpreted*. In this case, if you type into a cell formatted as Text, your typing is not interpreted into a proper date but remains as text with the appearance of a date. In addition, interpretation can change the format of a cell.
I trust this helps. Brian Barker --------------------------------------------------------------------- To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org
