I have been using shared hosting services from various providers and I thought it is time to use a virtual private server (VPS). I was told that Digital Ocean is a great option. So I did try Digital Ocean, and I wasn't disappointed. They have great service, and a fast server. It is also easy to add another VPS, and it is also easy to delete if you don't need it anymore. I've been using Digital Ocean's service for months now and I highly recommend it. For more information click here.
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