To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=105040
------- Additional comments from reg...@openoffice.org Mon Sep 14 11:27:56 +0000 2009 ------- You cannot search for the apostrophe, because it is not there. For example enter '567 into cell A1. The cell content is now the text 567. If you use =LEN(A1) in cell B1 you will get 3 not 4. The cell content has no apostrophe. The apostrophe is only shown in edit mode to distinguish text from numbers if necessary. For your actual converting problem the extension "Convert Text To Number (and date)" might help you. But work on a copy of your spreadsheet document, I have not tested that extension. http://extensions.services.openoffice.org/project/CT2N --------------------------------------------------------------------- Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification --------------------------------------------------------------------- To unsubscribe, e-mail: issues-unsubscr...@sc.openoffice.org For additional commands, e-mail: issues-h...@sc.openoffice.org --------------------------------------------------------------------- To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org
