Harold Fuchs wrote:
On 31/12/2007, [EMAIL PROTECTED] <
[EMAIL PROTECTED]> wrote:
Hi,
In Calc, is there a way to display a checkbox - checked or
unchecked instead of a TRUE/FALSE for a Yes/No boolean statement?
Thanks
*Jean-Claude Destruel*
[EMAIL PROTECTED]
The nearest to a check mark I can get is the mathematical symbol for square
root ("√") which you can get via Insert>Special Symbol and which you could
use in an IF function such as =IF(A1>5;"√";" ")
Hopefully someone else can do better ...
There are indeed better choices.
Choose a font that contains a large number of Unicode characters,
notably the Zapf Dingbat set and other symbols. Full Unicode contains
the proper Unicode checkmark symbol in regular and bold, as well as
checked and unchecked ballot boxes.
See http://unicode.org/charts/PDF/U2700.pdf and
http://xml.web.cern.ch/XML/www.unicode.org/charts/PDF/U2600.pdf .
See http://www.alanwood.net/unicode/dingbats.html and
http://www.alanwood.net/unicode/miscellaneous_symbols.html for other
listings which include names of fonts you can search for and download
which contain most or all of these characters.
Jim Allan
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
