problem shows symbol "û" instead of right & wrong mark by using XL2BB tool

L

leap out

Active Member

Joined

Dec 4, 2020

Messages

277

Office Version

1. 2016
2. 2010

• Mar 14, 2023

• #1

Hi experts ,
Recently, I published some topics that contain a true or false flag using this formula

=IF(E2=0,CHAR(252),CHAR(251))

Unfortunately, when using XL2BB tool , it will only appear as an symbol û instead of showing a true or false flag
The question is, Either is the problem with my account settings or XL2BB tool that does not show the right or wrong sign?

 

Fluff

MrExcel MVP, Moderator

Joined

Jun 12, 2014

Messages

90,849

Office Version

1. 365

Platform

1. Windows

• Mar 14, 2023

• #2

XL2BB shows everything using the "Arial Unicode MS" font, not the font you are using in your sheet.

 

L

leap out

Active Member

Joined

Dec 4, 2020

Messages

277

Office Version

1. 2016
2. 2010

• Mar 21, 2023

• #3

so in this case I have to capture the picture instead of use XL2BB , right?

 

Fluff

MrExcel MVP, Moderator

Joined

Jun 12, 2014

Messages

90,849

Office Version

1. 365

Platform

1. Windows

• Mar 21, 2023

• #4

To show the font, yes.

 

L

leap out

Active Member

Joined

Dec 4, 2020

Messages

277

Office Version

1. 2016
2. 2010

• Mar 21, 2023

• #5

thanks for clarification .

 

Fluff

MrExcel MVP, Moderator

Joined

Jun 12, 2014

Messages

90,849

Office Version

1. 365

Platform

1. Windows

• Mar 21, 2023

• #6

You're welcome.

 

smozgur

BatCoder

Builders Club Member

Joined

Feb 28, 2002

Messages

2,571

• Oct 23, 2023

• #7

leap out said:

so in this case I have to capture the picture instead of use XL2BB , right?

Click to expand...

@leap out: Wingdings in XL2BB v2.1. Just FYI.

Wingdings
	A	B	C	D	E	F	G	H	I
1	!	:	S	l	…	ž	·	Ð	é
2	"	;	T	m	†	Ÿ	¸	Ñ	ê
3	#	<	U	n	‡		¹	Ò	ë
4	$	=	V	o	ˆ	¡	º	Ó	ì
5	%	>	W	p	‰	¢	»	Ô	í
6	&	?	X	q	Š	£	¼	Õ	î
7	'	@	Y	r	‹	¤	½	Ö	ï
8	(	A	Z	s	Œ	¥	¾	×	ð
9	)	B	[	t		¦	¿	Ø	ñ
10	*	C	\	u	Ž	§	À	Ù	ò
11	+	D	]	v		¨	Á	Ú	ó
12	,	E	^	w		©	Â	Û	ô
13	-	F	_	x	‘	ª	Ã	Ü	õ
14	.	G	`	y	’	«	Ä	Ý	ö
15	/	H	a	z	“	¬	Å	Þ	÷
16	0	I	b	{	”		Æ	ß	ø
17	1	J	c	|	•	®	Ç	à	ù
18	2	K	d	}	–	¯	È	á	ú
19	3	L	e	~	—	°	É	â	û
20	4	M	f		˜	±	Ê	ã	ü
21	5	N	g	€	™	²	Ë	ä	ý
22	6	O	h		š	³	Ì	å	þ
23	7	P	i	‚	›	´	Í	æ	ÿ
24	8	Q	j	ƒ	œ	µ	Î	ç	#N/A
25	9	R	k	„		¶	Ï	è	#N/A
Wingdings

Cell Formulas
Range	Formula
A1:I25	A1	=WRAPCOLS(CHAR(SEQUENCE(255-32,,33)),25)
Dynamic array formulas.