Re: #VALUE! Error
I do have AOO vers 4.1.13 as well as LO vers 7.3; but I also make the mistake of sending my OP to AOO List when it could have/should have been sent to the LO List. Getting old is Not fun~!~ On 8/28/2022 7:58 PM, David Robley wrote: I think you have LibreOffice, as Apache OpenOffice is only at version 4.1.13. There may be differences between the two programs that could in some cases make a difference to the answers to questions; please make sure you are clear about what software you are using. On 29/8/22 00:19, Vince@Verizon wrote: I have a vers: 7.3.2.2 Calc sheet on my Win10x64 Home Cheers
Re: #VALUE! Error
I think you have LibreOffice, as Apache OpenOffice is only at version 4.1.13. There may be differences between the two programs that could in some cases make a difference to the answers to questions; please make sure you are clear about what software you are using. On 29/8/22 00:19, Vince@Verizon wrote: I have a vers: 7.3.2.2 Calc sheet on my Win10x64 Home Cheers -- David Robley Artist seeks Boss with vision impairment. - To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org
Re: #VALUE! Error-- SOLUTION Found
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
Re: #VALUE! Error-- SOLUTION Found
On 8/28/2022 10:49 AM, Vince@Verizon wrote: {{{ snipped }}} I don't know why I am getting a #VALUE! error in cell [H4]. Probably something simple... but it escapes me How can this be corrected? {{{ snipped }}} I now know why and how to correct this error. I found that when entering the starting date in cell A4, if I initially enter02/23/2022, rather than 23 February 2022, the result in cell H4 is correct; e.g., 186. So, to Brian's point, error 519 resulted at H4 because 23 February 2022 when typed from my keyboard, indeed is a text string instead of a number value and "/is not a date in spreadsheet terms/". { TNX Brian! } In the future I must pay closer attention and utilize the correct methodwhen wanting to type a date value within a cell. I also must remember that the cell format is only controlling what is displayed on screen. My apology for my mistakes when writing my OP. Sometimes what appears on the mail list becomes corrupt. If the mail list permitted attachments and/or copying and pasting of what is displayed on the Calc screen, I think I would be making fewer mistakes when posting ... Regards, VinceB.
Re: #VALUE! Error
On 8/28/2022 10:49 AM, Vince@Verizon wrote: [snipped] Cells A4 and B4 are formatted as Date, D, . Misspoke; meant to write: DD [snipped] The calculated results in those cells are: 23 February 2022 28 August 28 2022 #VALUE! Another of my errors. Should be: August 28 2022. [snipped]
Re: #VALUE! Error
At 10:49 28/08/2022 -0400, Vince Bonly wrote: I have a vers: 7.3.2.2 Calc sheet on my Win10x64 Home, build 19043, desktop with labels for columns A, B and H as follows: [A] ... [B] ... [H] Delivery Date ... Today Is ... Days Since Delivery The data within cells A4, B4 and H4 are as follows: 23 February 2022 ... =TODAY() ... =B4-A4 Cells A4 and B4 are formatted as Date, D, . The calculated results in those cells are: 23 February 2022 ... 28 August 28 2022 #VALUE! I'm not sure I believe that! I don't see why you have two 28s in B4. And in any case, your format would include a comma: August 28, 2022 I don't know why I am getting a #VALUE! error in cell [H4]. Probably something simple... but it escapes me #VALUE! is error 519, which often means that a referenced cell contains text instead of the required number. You are looking at and copying for us that date in A4, but I'm having to guess that what you have there is actually a text string, not a date in spreadsheet terms. (Again, if the cell format was controlling what you see, there would be a comma.) Note that formatting A4 with a date format will not change the contents of the cell - so if, say, you pasted the date from somewhere else as text, it will still be text despite the cell format. How can this be corrected? The best way is to ensure that your data is entered correctly in the first place, so that dates you need to calculate with are genuine dates, not text. But there is a simple workaround if you now have text values. Just change your formula to =B4-VALUE(A4) The VALUE() function will force the program to reinterpret the text value to an actual date value before performing the subtraction. 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
#VALUE! Error
Hi: Hope all is well with you and yours. I have a vers: 7.3.2.2 Calc sheet on my Win10x64 Home, build 19043, desktop with labels for columns A, B and H as follows: [A] [B] [H] Delivery Date Today Is Days Since Delivery The data within cells A4, B4 and H4 are as follows: 23 February 2022 =TODAY() =B4-A4 Cells A4 and B4 are formatted as Date, D, . The calculated results in those cells are: 23 February 2022 28 August 28 2022 #VALUE! I don't know why I am getting a #VALUE! error in cell [H4]. Probably something simple... but it escapes me How can this be corrected? TNX. VinceB.