64 bit binary conversion

Hello,
I'm new to this forum.
I'm trying to convert large decimal numbers to binary. Excel alone doesn't support that of course (DEC2BIN is very limited).
I need a formula that will get as inputs a decimal number and the number of output bits. The output should be the binary number, split to the cells under the decimal one if possible, and padded with zeros according to the number of bits.
This function is aimed to create a bitmap out of a decimal number.

I found a very good partial answer in this thread:
http://www.excelforum.com/excel-prog...it-binary.html

As i mentioned i'm very new to this forum and never used visual basic functions in excel. So please be as detailed as you can in the answer. on the thread mentioned before i was told to hit Alt+F11 and put it in a new module. These are not enough details for me need detailed tasks, how and where to push and paste, how to save, what does it mean, and how to use the function afterwards..

Thank you very much in advance!

Alon

Originally Posted by alonglick

I'm trying to convert large decimal numbers to binary.
[....]
I found a very good partial answer in this thread:
http://www.excelforum.com/excel-prog...it-binary.html

As i mentioned i'm very new to this forum and never used visual basic functions in excel. So please be as detailed as you can in the answer. on the thread mentioned before i was told to hit Alt+F11 and put it in a new module. These are not enough details for me need detailed tasks, how and where to push and paste, how to save, what does it mean, and how to use the function afterwards.

I'm afraid I do not have time now to walk you through it. I'm sure someone else will.

But I wanted to caution you that even though the UDF supports integers as large as 2^63-1 (i.e. 64-bit signed integers), if your integers have more than 15 significant digits, you will need to input them as text.

The previous discussion (in 2010) referred to input using a CSV file. If the file contains the number 1,234,567,890,123,456,789, for example, and you open it directly in Excel, Excel will interpert the number as 1,234,567,890,123,450,000, even if the number is quoted in the CSV file.

Instead, you need to import the file as a text file, and you need to set the imported column to type Text. (FYI, you do not need to change the file extension to ".txt", as some responders might say.)

Those might be some additional instructions you need more details about.

hi

http://www.ablebits.com/office-addin...a-macro-excel/
thanks

Thanks guys for the answers.
Maybe i should ask a more simple question - Is there a way to do just a decimal to binary up to 64 bit? no need to spread it to columns cause i guess this excel can do.
Thank you!

Thank you very much martindwilson.
It looks great BUT after downloading the file and "Enable content" and "Enable Editing" it gives me an "Compile error: can't find project or library".
What should i do to get it working. i think this is exactly the function i was looking for.
Thank you!

Str$
does it make sense?
Thanks!

I tried the solver addin and it didn't help
any other options?
Thanks!

Try:

Please Login or Register  to view this content.

YEAH!!!! working!
Thanks a lot
what was the problem?

Where do you "untick" it?

Tools->References

Got it.
Thank you!!