•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Why are my male/female symbols missing?
Our take
If you're encountering issues with missing male and female symbols in Excel, you're not alone. Many users have faced similar challenges, particularly when trying to input specific Unicode characters like 2642 for the male symbol. The confusion can arise from font variations, as you've discovered that the Arial font displays these symbols while others do not. Understanding font compatibility is essential for accessing the full range of Unicode characters.
The internet says 2642 is the code for the male symbol. Only, for me, it produces Latin Small Letter Rams Horn. Furthermore, I saw someone mentioned a subset called Miscellaneous Symbols. I don't have that -- only Miscellaneous Technical. I am unable to find the male/female symbols anywhere in Excel.
Can anyone help?
EDIT: I solved it. For some reason it appears when the text is Arial but not (normal font). Weird.
[link] [comments]
Read on the original site
Open the publisher's page for the full experience
Tagged with
#Excel alternatives for data analysis#natural language processing for spreadsheets#generative AI for data analysis#Excel compatibility#Excel alternatives#rows.com#no-code spreadsheet solutions#male symbol#female symbol#Excel#Unicode#Miscellaneous Symbols#symbols#code 2642#Miscellaneous Technical#Arial#Latin Small Letter Rams Horn#font#Unicode character#text display