2009/9/26 Harold Fuchs <hwfa.openoff...@googlemail.com>: > Wade Smart wrote: >> >> Harold Fuchs wrote: >>> >>> 2009/9/26 Wade Smart <w...@wadesmart.com> >>> >>>> Harold Fuchs wrote: >>>> >>>>> 265879-09-24-71-918-333-0055 >>>> >>>> Assuming the "71" part of your string is always in the same position - >>>> two >>>>> >>>>> characters long, starting at the 14th character - and assuming the >>>>> strings >>>>> are in column A and you want answers in column B, then enter into >>>>> column B >>>>> the formula >>>>> >>>>> =YEAR(NOW())-1900-VALUE(MID(A1;14;2)) >>>>> >>>>> In fact, if your strings are fixed format then using the MID function >>>>> is >>>>> much easier than my previous solution using Regular Expressions. >>>>> >>>> I get ERROR: 502 when I try this. >>>> >>>> On my version of OO I have to use , instead of ; - though I still get >>>> the >>>> error. >>>> >>>> Question. I looked up Value and it says it converts a text string to a >>>> number. If we are already working on a number, is that needed? >>>> >>>> >>>> Wade >>>> >>>> >>> Two questions: >>> >>> 1. How *exactly* have you formatted the column containing your >>> "numbers"? >>> >>> 2. If you select a single one of your "number" cells, say the cell >>> containing your example, *exactly* what do you see in the Input line? >>> >>> >> >> The spreed sheet is sent to me with certain information already in it. >> The column with the numbers is formated as "number". >> >> I see the number as printed above aligned to the left hand side of the >> column. >> >> wade > > Hmmm. Now I'm really confused. My formula (the one with MID ...) just works > on my system_s_ - Windows Vista Home Premium running OOo 3.1 and Windows XP > Pro running OOo 2.4.1. > > The fact that you say you have to use commas in the formula instead of > semicolons worries me. It makes me think you have some weird version of OOo > and that this weirdness is also causing the error message. But I'm out of my > depth here. Perhaps someone else could help??? Please. >
Well, could it be that he is not running an English version? For instance, the Swedish version (which I use) has its formula statements translated to Swedish (things like ”IF”, VLOOKUP” and, well, anything is translated to Swedish). Maybe it's the same thing with his version, but another language than English or Swedish (even the Swedish version use ”;” rather than ”,”). Just a thought. J.R. --------------------------------------------------------------------- To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
