To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=5658
------- Additional comments from [EMAIL PROTECTED] Mon Jun 23 19:22:04 +0000 2008 ------- Not sure if this is of any use to anyone: =IF(ISERR(VALUE(A1));"text";IF(VALUE(A1)=(A1+0);"num";"numtext")) These tests check whether the value of A1 is a number, a text value that can be converted to a number, or a text value that can't be converted to a number. --------------------------------------------------------------------- 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]
