Hello Ann, just enter it as 'True
By using the apostrophe the following text is handled as text. Otherwise the "TRUE" is handled as function which gives 1 (formatted as "TRUE") as return value.
I am new to OO, but am loving it thus far. I do have a dilemna with the TRUE function. I have created a database of personal contact info for an exhibit I am curating. One of the artists has the surname of 'True'. I've tried again and again to enter as such, but Calc automatically changes it to 'TRUE' and apparently attaches the TRUE function to it. It also lists the name at the top of the list when I sort the data. Please advise on how to override this.
Kind regards, Joost --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
