Costum formula in excel

[Cool Buddy]

I used this page's code to define a formula in excel. however the formula is appearing only in the workbook that is open at that time. how to use the formula across excel?

In case you want to try the formula, remove the two _ (undescores) and the line break after that to get the code working.

[Cool Buddy]

Where are the techies of digit? i really want a solution, is it possible at all? can the mods help?

[Cool Buddy]

I am still wondering why there was not a single reply to this post. however, I found a solution, i copied the code to the workbook where excel stores macros when we store it outside the workbook (personal.xlsb in excel 2007). now the formula appears in all workbooks (prepended with the workbook's name).