1

When I write a flag emoji like 🇨🇳 into a Google Sheets cell it displays as text and not as a flag when I am using Google Chrome or Microsoft Edge in Windows 10. Is there a way to display it as a flag with this setup?

Here is a sample spreadsheet which replicates the issue: https://docs.google.com/spreadsheets/d/1Q9F237ay3IMYh-qULXSpQUx4-0_cPj-xoQWeQ2_-ooE/edit?usp=sharing

Improve this question
6
  • When I copy and paste 🇨🇳 to a Google Sheet, the flag displays in the cell just fine. Tested on Safari on macOS. Consider sharing a publicly editable sample spreadsheet where the issue can be reproduced. There is a blank sheet maker that lets you share safely.
    – doubleunary
    May 25 at 11:00
  • @doubleunary thank you for the input. I have added more information about my set-up and a sample spreadsheet.
    – Toivo Säwén
    May 25 at 13:45
  • 1
    I see the flags and country names in cells B10:F10 just fine, and the flags also show fine in the X axis labels in Chart1. It is unlikely that the issue is with Google Sheets. Try with another browser, and check your system for broken fonts and the like to identify what the problem is.
    – doubleunary
    May 25 at 21:16
  • @doubleunary have you tried it in Google Chrome on Windows 10?
    – Toivo Säwén
    May 26 at 11:39
  • I have the same issue in Microsoft Edge.
    – Toivo Säwén
    May 26 at 11:41

0

Reset to default

Browse other questions tagged or ask your own question.