2009/9/26 Wade Smart <[email protected]> > 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? -- Harold Fuchs London, England Please reply *only* to [email protected]
