Re: [libreoffice-users] CALC convert text to numbers

On 11/10/2013 06:32 PM, Brian Barker wrote:
> At 21:17 10/11/2013 -0500, Jay Lozier wrote:
> > Why not set a cell to the formula =right(len(CELL)-1) which returns 
> > the all the characters except for the first.
>
> That's =RIGHT(Xn;LEN(Xn)-1) - but that won't strip the single quote 
> mark because it's *not there*!  The simpler formula =RIGHT(Xn;LEN(Xn)) 
> would work, but that's just a complicated way of saying =VALUE(Xn).
>
> Brian Barker
Why is everyone straying away from the fact that there is a simple 
extension developed by Cor (one of our brilliant devs) which 
accomplishes all of this? Just curious if there's a benefit to doing 
these formula techniques instead of just pushing a button on a nice gui


All the best,
Joel

--
To unsubscribe e-mail to: users+unsubscribe@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted