Paulo Buchsbaum
Reputation: 2659
Why the same ascII code shows different symbols in Excel?
It's crazy. I paste the ∞ symbol in Excel in A1 and I put the formula =code(A1) in B2.
It shows 63. After I digit =char(63) in A2, it shows ? symbol.
When I test =(A1=A2) it's false
If I copy formula and paste value for A2, continue to be false.
Why? How it's possible the same ASCII code shows 2 different symbols?
My version is Excel 2003 and 2010
Upvotes: 0
Views: 966
Answers (1)
Related Questions
- Excel cell has an invisible character
- Writing to Excel using openpyxl results in a different character symbol
- VBA code causing inexplicable characters in excel
- How does ASCII 0x00A0 becomes 0x00E1
- Why does the same character render different ways in Windows applications?
- Excel : All other language symbols are getting converted to?
- recognizing special characters outside a certain ASCII range in excel does not always work
- Excel VBA - my VBA Code got messed up: why the spanish characters (á,é,í,ó,ú,ñ,¡,¿) mutated?
- Excel not displaying unicode characters
- Currency code comes with Unicode while export to excel