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

Question

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

Answer 1

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