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
--
Registered Linux User: #480675
Registered Linux Machine: #408606
Linux since June 2005
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
