Harold Fuchs wrote:
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.
Im on ubuntu 9.04 with OO 3.0.1, OOO300m15 Build: 9379.
Pradeep Srinivas of this list figured it out.
But its not a big deal as we do have something working - its really
helping with my work load :D
Thanks for the help Harold.
--
Registered Linux User: #480675
Registered Linux Machine: #408606
Linux since June 2005
---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscr...@openoffice.org
For additional commands, e-mail: users-h...@openoffice.org
