How can I make a simple check mark column?
 

How can I make a simple check mark column?
 

Please enter your question in the body of the post, and include all
pertinent information.

Format the column to Wingdings 2,
And type in an upper case P,
OR,
An upper case R.
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"PeterB" wrote in message
...

How can I make a simple check mark column?
 

Format to Marlett font and type an "a" without the quotes.


Gord Dibben MS Excel MVP

On Tue, 19 Sep 2006 11:58:01 -0700, PeterB
wrote:

How can I make a simple check mark column?
 

Thank you. However, I wonder if there is a simple result that would allow
hitting the space bar in the field to toggle a checkmark?

"Gord Dibben" wrote:

Format to Marlett font and type an "a" without the quotes.


Gord Dibben MS Excel MVP

On Tue, 19 Sep 2006 11:58:01 -0700, PeterB
wrote:

How can I make a simple check mark column?
 

Not that I know of.


Gord

On Tue, 19 Sep 2006 15:49:02 -0700, PeterB
wrote:

Thank you. However, I wonder if there is a simple result that would allow
hitting the space bar in the field to toggle a checkmark?

"Gord Dibben" wrote:

Format to Marlett font and type an "a" without the quotes.


Gord Dibben MS Excel MVP

On Tue, 19 Sep 2006 11:58:01 -0700, PeterB
wrote:




Gord Dibben MS Excel MVP

How can I make a simple check mark column?
 

I find this technique pretty easy...

Select the range
Format|cells|number tab|custom category
In the "type:" box, put this:
alt-0252;alt-0252;alt-0252;alt-0252

But hit and hold the alt key while you're typing the 0252 from the numeric
keypad.

It should look something like this when you're done.
ü;ü;ü;ü
(umlaut over the lower case u separated by semicolons)

And format that range of cells as Wingdings.

Now, no matter what you type (spacebar, x, anyoldtextatall), you'll see a check
mark.

Hit the delete key on the keyboard to clear the cell.

If you have to use that "checkmark" in later formulas:

=if(a1="","no checkmark","Yes checkmark")

PeterB wrote:

Thank you. However, I wonder if there is a simple result that would allow
hitting the space bar in the field to toggle a checkmark?

"Gord Dibben" wrote:

Format to Marlett font and type an "a" without the quotes.


Gord Dibben MS Excel MVP

On Tue, 19 Sep 2006 11:58:01 -0700, PeterB
wrote:




--

Dave Peterson