JOE Conner wrote:
On 7/31/2010 10:54 AM, Wade Smart wrote:
Dave Barton wrote:
-------- Original Message --------
From: Wade Smart <[email protected]>
To: [email protected]
Date: Sat, 31 Jul 2010 10:46:42 -0500
I need to get the product code from a numeric string.
I tried RIGHT(C2,4) but apparently this only works with letters and not
numbers.
Wade
Does =RIGHT(TEXT(C2,"#"),4) do what you want?
Dave
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
no.
=RIGHT(TEXT(C2,"#"),4)
C2 = .. (last six digits) 0/1981
the above function produces 9736
Wade
I think your problem stems from the way dates are stored in a cell. The
actual contents of a cell containing is a real number, only just
formatted to look like a date. The number zero in a cell formatted to a
date will have the date 12/30/1899. Any date after that is internalized
by the number of days since that zero date.
I hope this provides you with an avenue to explore to obtain your
desired result.
Joe Conner, Poulsbo, WA USA
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
You fingered it Joe. I checked the column and its formated as date.
I copied the number over to a new column formatted as text and it works
great.
Question: how do you reformat as text without loosing all the data?
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]
