Home |
Search |
Today's Posts |
#7
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
On Sep 23, 6:17*pm, "Peter T" <peter_t@discussions wrote:
You can get 10 digit hex numbers with the Hex2Dec function in Analysis Tool Pack addin (or the version for use with VBA). Input 9320545500 Output 22B8C3CDC input 9320545566 output 22B8C3D1E Note Hex2Dec returns a different construct to VBA's Hex depending on the number. Those 48-char Hex numbers in theory represent a number somewhere between 3.9E+56 to 3.14E+57 However I kind of assume they represent some sort of code, you'd need to give more information. Regards, Peter T "Madiya" wrote in message Yes, You are right. I am getting error in VBA function Hex(1234567890) . Error is "Runtime error '6' ", Over Flow. Here is an example of input and output reqd. input 9320545500 output EDD7EA6A0CDC5CA7212187EB854408ADF73E7F7BA2FF95BA input 9320545566 output 695B91538F72D3B2F0BED374FA4E02A9634A1C4CE9292966 Pl help. Regards, Madiya Thanks Peter. But I have no idea what code it is. In fact I have derived this hex from the resultent url of the web page We have to enter the 10 digit no in the text box and click submit button. A new page loaded in browser will show related details with the above output appended at the end of the url. Shell I post the html source code of the page? Can that be of any help? Regards, Madiya |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Excel 2002 : Convert Positive Numbers to Negative Numbers ? | Excel Discussion (Misc queries) | |||
Convert numbers stored as text to numbers Excel 2000 | Excel Discussion (Misc queries) | |||
convert negative numbers to positive numbers and vice versa | Excel Worksheet Functions | |||
How do I convert numbers stored as text with spaces to numbers | Excel Discussion (Misc queries) |