NUMTEXT

[schardt679]

NUMTEXT leaves text including blanks alone, converts yes's/true's to 1's, no's/false's to 0's, and converts numbers stored as text to numbers

=LAMBDA(Array,
     LET(Arr, Array,
        Return, SWITCH(Arr&"", "", "",  "YES", 1,  "NO", 0,  IFERROR(--(Arr), Arr)),
        Return
     )
  )

LAMBDA Functions.xlsx
	A	B	C	D	E	F	G
1		Original Data			Results
2		apple	banana		apple	banana
3		123-456	pear123		123-456	pear123
4		7862			7862
5		4/3/2021	4/3/2021		44289	44289
6		1	0		1	0
7		YES	NO		1	0
8		yes	no		1	0
NUMTEXT

Cell Formulas
Range	Formula
E2:F8	E2	=NUMTEXT(B2:C8)
C5	C5	=TODAY()
Dynamic array formulas.