Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Thunderace
 
Posts: n/a
Default can you put a tick into an excel cell?


  #2   Report Post  
 
Posts: n/a
Default

hi
no. you can put a tick on the sheet but not "in" a cell.

-----Original Message-----

.

  #3   Report Post  
Sandy Mann
 
Posts: n/a
Default

Thunderace,

in cell A33 enter the formula =CHAR(ROW()) and copy down to row 255

With the range still highlighted, change the font to Wingdings and you will
see the full Wingdings character set. Character 252 is a tick sign. You
can enter the tick in a cell either by the formula =CHAR(252) with the cell
font set to Wingdings or by holding the the Alt key while you enter 0252
from the number pad keys.

Also have a look to see the full charater set of the other fonts that you
have out of interest.

HTH

Sandy

--
to e-mail direct replace @mailinator.com with @tiscali.co.uk


"Thunderace" wrote in message
...



  #4   Report Post  
Jim May
 
Posts: n/a
Default

In the cell you want to show the CHECK-MARK
enter the letter "a" -- without the quotes
Then assign the font "Marlett"



"Sandy Mann" wrote in message
...
Thunderace,

in cell A33 enter the formula =CHAR(ROW()) and copy down to row 255

With the range still highlighted, change the font to Wingdings and you

will
see the full Wingdings character set. Character 252 is a tick sign. You
can enter the tick in a cell either by the formula =CHAR(252) with the

cell
font set to Wingdings or by holding the the Alt key while you enter 0252
from the number pad keys.

Also have a look to see the full charater set of the other fonts that you
have out of interest.

HTH

Sandy

--
to e-mail direct replace @mailinator.com with @tiscali.co.uk


"Thunderace" wrote in message
...





Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How do I unhide the cell format function in Excel 2000 Len Melcer Excel Worksheet Functions 2 December 15th 04 06:49 PM
Excel: how to formulate conditional cell references centraloffice Excel Worksheet Functions 1 December 10th 04 08:57 PM
Paste rows of numbers from Word into single Excel cell BecG Excel Discussion (Misc queries) 1 December 8th 04 04:55 PM
Writing many lines on a same Excel 2000 cell freeposte Excel Discussion (Misc queries) 2 December 8th 04 02:45 PM
Can 2 different hyperlinks be in the same Excel cell? rynes01 Excel Worksheet Functions 2 December 7th 04 05:15 PM


All times are GMT +1. The time now is 02:21 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"