To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=69854
User fst changed the following:
What |Old value |New value
================================================================================
Status|UNCONFIRMED |RESOLVED
--------------------------------------------------------------------------------
Resolution| |DUPLICATE
--------------------------------------------------------------------------------
------- Additional comments from [EMAIL PROTECTED] Tue Sep 26 02:22:17 -0700
2006 -------
Hi,
this is a double to Issue 28359.
The leading apostrophe is intentional and also used by Excel in this case. It
makes a number a text in a number formatted cell. This has to works as it does
now because you may want to have the numbers as text even if you change the
format of such cells back to numbers, e.g. ZIP Codes in the US or other numbers
with leading zeros.
For a solution to convert such text values into numbers with Find&replace, have
a look at the double Issue.
Frank
*** This issue has been marked as a duplicate of 28359 ***
---------------------------------------------------------------------
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: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
