I don't know if you solved it yet, but there is an easy way to eliminate that ' character from the spreadsheet. Insert a new column next to the one you want to work with and use the "=value()" command. For example: in column A cell 1 you have '2346, in column cell 1 enter: =value(A1) This will copy only the numbers from that cell.
This worked fine for me and I hope it will be useful for others. -- View this message in context: http://openoffice.2283327.n4.nabble.com/Calc-remove-character-before-number-tp2914702p3414790.html Sent from the openoffice - users mailing list archive at Nabble.com. -- ------------------------------------------------------------------------ To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected] with Subject: help
