Search code examples
excelplatform-detection

Code / Ascii function in VBA Excel on MAC vs on PC

On a PC I have these chars with their ASCii code 178,188,189 respectively. But when I use the CODE function on MAC VBA Excel I always get 95 for all three different chars.

char    PC  MAC
²       178 95
½       188 95
¾       189 95

How can I distinguish between these 3 chars on the MAC? or phrased differently, is there a function on the MAC VBA Excel that gives me different values for these 3 chars, even if they are "MAC Ascii" values, as long as they are different

Solution

  • The table you gave for the ASCII codes is wrong.

    The correct table is:

    char    PC  MAC
²       178 253
½       189 171
¾       190 243

    Hope it helps