| Home |
| Search |
| Today's Posts |
|
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
convert hex-values to decimal values
or clng, etc.
On Thu, 28 Aug 2003 10:22:34 +0100, "Keith Willshaw" wrote: "Markus Früh" wrote in message ... hello thanks for the link. but there is no help. they write about a function called HEX2DEC() , but i do not have such a function? i have installed all "add-ins" but my excel2000 (german) do not find this function? has anybody an other solution? thanks markus Sorry I misread your post The function you need is Variant=CDEC("String") Where String is the hex number prefixed with &H Thus MsgBox CDec("&HC1A") would output 3098 Keith |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Net should be zero but it is not; decimal values aroung the 12 dec | Excel Worksheet Functions | |||
| Decimal Values | Excel Discussion (Misc queries) | |||
| How do I convert decimal values to hours & minutes in Excel 2000? | Excel Discussion (Misc queries) | |||
| Hiding certain decimal values | Excel Worksheet Functions | |||
| How to convert decimal values (dd.dddddd) to degrees/minutes/seco. | Excel Worksheet Functions | |||
![Wild Bill[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
