Wade Smart wrote:
Harold Fuchs wrote:
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?
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.
--
Harold Fuchs
London, England
Please reply *only* to [email protected]
