LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default error when I try to convert hex to bin with more than 8 chacters?

=dec2bin("5600",16) will return #NUM?
I check the help it should work fine?
I was using the hex2bin function too and it behaves same.
How should I convert the dec or hex to bin with more than 8 bits?

 
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
Limit number of chacters in cell plunk25 Setting up and Configuration of Excel 1 February 20th 07 07:03 PM
Error Checking - Convert to Number dbarelli[_22_] Excel Programming 1 August 16th 06 03:57 PM
How to convert VLOOPUP error value #NA to 0? Rex Excel Worksheet Functions 4 February 26th 06 12:23 PM
error convert to number macro cherrynich Excel Programming 3 January 19th 06 01:26 PM
How do you extract numbers from a string of chacters in a cell (E. blackbeemer Excel Worksheet Functions 6 November 12th 04 09:00 AM


All times are GMT +1. The time now is 03:39 AM.

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"