-------- Original Message -------- From: Wade Smart <[email protected]> To: [email protected] Date: Sat, 31 Jul 2010 14:47:07 -0500
> Dave Barton wrote: >> -------- Original Message -------- >> From: Dave Barton <[email protected]> >> To: [email protected] >> Date: Sun, 01 Aug 2010 05:10:14 +1000 >> >>> -------- Original Message -------- >>> From: Wade Smart <[email protected]> >>> To: [email protected] >>> Date: Sat, 31 Jul 2010 12:54:14 -0500 >>> >>>> 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 >>>>> >>>> no. >>>> >>>> =RIGHT(TEXT(C2,"#"),4) >>>> C2 = .. (last six digits) 0/1981 >>>> the above function produces 9736 >>>> >>>> Wade >>> Please provide more information about the contents of cell C2. Your >>> email header suggests you may be running some flavour of Linux. Are you >>> using the OOo standard edition from the OOo website, or a distro >>> supplied edition? >>> >>> I cannot replicate your results. If I simply enter 0/1981 in cell C2 my >>> suggestion does not work, because Calc appears to treat the contents of >>> cell C2 as text. In which case your original formula: >>> =RIGHT(C2;4) for the OOo standard edition >>> or >>> =RIGHT(C2,4) for the Go-OO/Novel edition >>> should work. >>> >>> Dave >> >> I have now replicated your results by changing the contents of cell C2 >> to a date (sometime in 1981), not a product code number as indicated in >> your original email. >> >> Could it be that Calc is translating what you perceive as as a product >> code into a date? >> >> Dave >> >> >> --------------------------------------------------------------------- >> To unsubscribe, e-mail: [email protected] >> For additional commands, e-mail: [email protected] >> >> > > Im on Ubuntu 9.04, OO 3.0.1, OOO300m15 Build:9379. > > If I put this number into C2 and run it I get 1981. > Cell C2 = 2U915/ELEPVANISV0/1981 > > It might be taken for a date. > > Would the RIGHT() function not work on a date? > > Wade No the right function will not work on a date. See Joe Connor's reply for the explanation. Unless there is good reason not to, I suggest formatting your product code cells as text. This will prevent Calc from interpreting them as a date. Dave --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
