Number Conversion

[DP]

I can use hex([field]) to get a decimal number converted
to hexadecimal. How do I convert a hexadecimal number fo
decimal?

Thank you.

 

[Allen Browne]

? Val("&HFF")

 

[DP]

I'm sorry. I don't understand the answer. DP

-----Original Message-----
? Val("&HFF")

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.

I can use hex([field]) to get a decimal number converted
to hexadecimal. How do I convert a hexadecimal number fo
decimal?

Thank you.

 

[Allen Browne]

Use the Val() function to convert a string representing the hexadecimal
number.

For example, if you have the hex value in a field, and the &H prefix is not
in the field, use:
Val("&H" & [field])

(Apologies for the cryptically short reply. Made an assumption that anyone
asking about hex numbers would be used to working with these oddities.)

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.

I'm sorry. I don't understand the answer. DP

-----Original Message-----
? Val("&HFF")

I can use hex([field]) to get a decimal number converted
to hexadecimal. How do I convert a hexadecimal number fo
decimal?

Thank you.

 

[DP]

That was sufficiently verbose... thanks. (Working with
hexidecimal Unicode codes - know fonts not hexes.) DP

-----Original Message-----
Use the Val() function to convert a string representing the hexadecimal
number.

For example, if you have the hex value in a field, and the &H prefix is not
in the field, use:
Val("&H" & [field])

(Apologies for the cryptically short reply. Made an assumption that anyone
asking about hex numbers would be used to working with these oddities.)

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.

I'm sorry. I don't understand the answer. DP

-----Original Message-----
? Val("&HFF")

I can use hex([field]) to get a decimal number converted
to hexadecimal. How do I convert a hexadecimal number fo
decimal?

Thank you.

.