Got invited by one of my students to Ciao.It's a community site that is intended for the world's consumers (various products). What's interesting is that the site pays for your reviews from computer peripherals to kitchen appliances buying guide. Not only do they pay for reviews, they also pay for the comments you put on other users' reviews. Cool right? Well, if you're asking if they really pay or not, I cannot answer that yet as I have only made $4.21 as of today. They only allow payment requests when you reach $5. It's just a matter of time before I reach that amount and I verify if they really pay or not. I will be posting the results here. As far as I've heard, the site is really legit. Well, you'll never know unless you try. If you decide to join, then add me up. My user name is fiShBoN3.
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