Wade Smart wrote:
Johnny Rosenberg wrote:
2009/9/26 Harold Fuchs <[email protected]>:
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.
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: [email protected]
For additional commands, e-mail: [email protected]
Im running an Eng version.
Wade
Ubuntuized OOo is based on go-oo, and for some reason they are using
commas instead of semicolons in some formulas. Trouble is: They do not
modify the help files to tell which formula parameters they have modified.
Joe Conner, Poulsbo, WA USA
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
