Re: #VALUE! Error

2022-08-29 Thread Vince@Verizon
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

Re: #VALUE! Error

2022-08-28 Thread David Robley
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@Veri

Re: #VALUE! Error-- SOLUTION Found

2022-08-28 Thread Brian Barker
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 interpre

Re: #VALUE! Error-- SOLUTION Found

2022-08-28 Thread Vince@Verizon
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 ent

Re: #VALUE! Error

2022-08-28 Thread Vince@Verizon
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. Sho

Re: #VALUE! Error

2022-08-28 Thread Brian Barker
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 f

#VALUE! Error

2022-08-28 Thread Vince@Verizon
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 #