Buying Need small VB Code to use in Excel

Discussion in 'Programming' started by vahing, Jun 15, 2015.

  1. #1
    Hi,

    I need a piece of VB code (similar to http://answers.microsoft.com/en-us/...ls-value/845fbf97-89db-4935-871f-1e83f00881d2.

    I mean the UDF function there)

    Given a number like 1010010010110 it should render as

    = 1×2¹² + 0×2¹¹ + 1×2¹⁰ + 0×2⁹ + 0×2⁸ + 1×2⁷ + 0×2⁶ + 0×2⁵ + 1×2⁴ + 0×2³ + 1×2² + 1×2¹ + 0×2⁰

    I need this in an Excel worksheet, and the code should accommodate for large input numbers

    If you can do that quickly and inexpensive please get hold of me in Skype: markmu1965
     
    vahing, Jun 15, 2015 IP