What if IT people can have their own private network over the Internet? What if we can have our very own static IP address without having a subscription to Internet Service Providers? What if we can create our own Hamachi without having a central server? Just let the network reside over the network. What if the Internet fully becomes another autonomous world free from the rules within our own countries? What if I CAN MAKE IT HAPPEN?
I was asked today by one of my classmates about converting numeric values to literal values in excel. I thought there was a function for this but I found none. Well I was curious so I looked it up on the web . I've done a little modification here to make it more or less generic (specially when writing in checks). Here's how it's done: Click Tools->Macro->Visual Basic Editor Insert a module Paste the following code: Option Explicit '**************** ' Main Function * '**************** Function SpellNumber(ByVal MyNumber) Dim Temp, WholeNumberText, DecimalText Dim DecimalPlace, Count ReDim Place(9) As String Place(2) = " Thousand " Place(3) = " Million " Place(4) = " Billion " Place(5) = " Trillion " ' String representation of amount. MyNumber = Trim(Str(MyNumber)) ' Position of decimal pl...
Comments