Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 1
Default Format cells for special characters

I downloaded a "to do List" that has a function whereby entering "a" into the
cell, brings back the checkmark unicode character.

How is this set up?
  #2   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 22,906
Default Format cells for special characters

If the cell is formatted as Marlett font, typing an "a" will enter the
checkmark.

InsertSymbol will open a dialog so's you can see a list of fonts, characters
and the ascii number for each.

Or just StartRun "charmap" to open the Windows CharMap


Gord Dibben MS Excel MVP

On Thu, 8 Mar 2007 11:22:27 -0800, Mad Davy Cash <Mad Davy
wrote:

I downloaded a "to do List" that has a function whereby entering "a" into the
cell, brings back the checkmark unicode character.

How is this set up?


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
Format cells for special characters John Bundy New Users to Excel 0 March 8th 07 07:05 PM
Automatically highlight cells with special characters Matt B. Excel Discussion (Misc queries) 3 December 20th 06 11:58 PM
excel data label format special number characters (part 2) todd Excel Discussion (Misc queries) 1 May 4th 05 04:08 PM
excel data label format special number characters todd Excel Discussion (Misc queries) 0 May 4th 05 01:30 PM
REMOVE SPECIAL CHARACTERS FROM TEXT CELLS javila255 Excel Worksheet Functions 1 April 2nd 05 06:24 PM


All times are GMT +1. The time now is 01:00 AM.

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

About Us

"It's about Microsoft Excel"