LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #7   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 239
Default Convert numbers to HEX

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel 2002 : Convert Positive Numbers to Negative Numbers ? Mr. Low Excel Discussion (Misc queries) 2 November 6th 06 03:30 PM
Convert numbers stored as text to numbers Excel 2000 Darlene Excel Discussion (Misc queries) 6 January 31st 06 08:04 PM
convert negative numbers to positive numbers and vice versa bill gras Excel Worksheet Functions 4 December 7th 05 01:39 AM
How do I convert numbers stored as text with spaces to numbers Baffuor Excel Discussion (Misc queries) 1 May 24th 05 07:39 AM


All times are GMT +1. The time now is 02:48 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"