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


--
To unsubscribe e-mail to: users+unsubscr...@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

Reply via email to