Use of Monotype Sorts Font and Value 4

[JMay]

When I enter in a cell the value 4 and change font to Monotype Sorts
instead of getting a single CHECK-MARK I get the Check mark plus 3 other
characters
that look like a pencil stub. I only want to Check Mark.
Any suggestions?
TIA

 

[Chip Pearson]

I can't replicate your problem. I get only a check mark. Are you
sure there is nothing else in the cell. In another cell, use a
formula like =LEN(A1) to ensure that there is only one character
in the cell.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com

 

[JMay]

Thanks Chip; =Len(A1) >> 1
If I grab the right-side column hearer and drag reducing the width the
content changes from my checkmark + 3 pencil stubs to three pairs of
scissors -- LOL Crazy huh..
JMay

 

[Anders S]

Check the number format (General).

HTH
Anders Silven

 

[JMay]

Tks Anders,
Cell format was Numbers, Accounting.
Cell format General corrects..
Happy Easter!!


Check the number format (General).

HTH
Anders Silven

 

[Ragdyer]

NICE ! - How the heck did you ever figure that out?<bg>

Most folks use the more common WingDings2 font, where an uppercase *letter*
(P or R) will *not* change as the column changes widths.

 

[Anders S]

Just a lucky guess, I suppose. Numeric value + extra characters = number format.

Regards,
Anders Silven

 

[dardsa]

am looking for possible work-arounds to a similar problem

I use an IF formula to output a "-5" (negative five, integer) if my
criteria are not met. I then format the cell using
FORMAT CELLS>>NUMBER>>NUMBER>>NEGATIVE NUMBER>>OPTION 2
(that is, a negative number is displayed in red without the leading
"-" sign or trailing decimal spaces).

Using the monotype sorts font meant i saw a red "X" in cells that did
not meet my criteria. Easy to pick out in a long list and where the
cells that do meet my criteria are black tick marks, Monotype Sorts,
4.

Tickmark and crossmarks in Wingdings/Webdings fonts use alphabets &
special characters so the above trick will not work. Any suggestions
for a work-around?

Thanks in advance
Dar

 

[RagDyer]

What you are looking for is probably a perfect example of why "Conditional
Formatting" was instituted.

Besides just making your ticks red, you could also make the cell yellow.
That would really stand out!

Check it out in the help files, and post back if you need any additional
assistance.
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================



am looking for possible work-arounds to a similar problem

I use an IF formula to output a "-5" (negative five, integer) if my
criteria are not met. I then format the cell using
FORMAT CELLS>>NUMBER>>NUMBER>>NEGATIVE NUMBER>>OPTION 2
(that is, a negative number is displayed in red without the leading
"-" sign or trailing decimal spaces).

Using the monotype sorts font meant i saw a red "X" in cells that did
not meet my criteria. Easy to pick out in a long list and where the
cells that do meet my criteria are black tick marks, Monotype Sorts,
4.

Tickmark and crossmarks in Wingdings/Webdings fonts use alphabets &
special characters so the above trick will not work. Any suggestions
for a work-around?

Thanks in advance
Dar