How does one input a tick and cross sign in excel?

[excellator]

hi there
i recently created a worksheet for paid and unpaid invoices and just need to know if i can somehow put a tick and a cross sign showing whether it has been paid or not.

i just basically want to know i one cant put the tick and cross sign in excel and if i can then please tell me how coz i ahve been trying and trying but gettin no where.

example:

Amount Invoice# Date Paid
1546.00 bircs10198 06/06/08 tick or cross sign here

any help would be appreciated.

thx
xcltr

 

[Richard Schollar]

Hi

Apply the Marlett font to your cells where you want this tick or cross to be and either type in manually "a" or "r" (without the quotes) or set validation on the cells drawing from a comma delimited list of a,r.

 

[Eric Milne]

You could try using wingdings font and copy and paste the cross and tick characters from here: http://www.alanwood.net/demos/wingdings.html

i.e. use "ü" for a tick and "û" for a cross then set the cell fonts to wingdings.

 

[al_b_cnu]

Hi,


Try font 'webdings', with 'a' and 'r'

 

[excellator]

thx 2 all of you, all the methods work.

thx again.

 

[AbrahamGluck]

ü
How can I make this symbol in excel?

 

[al_b_cnu]

ü
How can I make this symbol in excel?

Hi, Try Insert > Symbol and select font "Yu Gothic"

 

[MrIfOnly]

A couple of options:

If you are using Windows, go to Settings and add the Deutsch language. Using the virtual keyboard you can add the ü character.

Also, you can use alt codes that are outlined in this very useful site: German symbols - fsymbols


Regards,

CJ

 

[Michael M]

OR "Vrinda" font