Archives by date

You are browsing the site archives by date.

Excel date to words formula

Function DateToWords(ByVal xRgVal As Date) As String ‘createbybhagchandsamota Dim xYear As String Dim Hundreds As String Dim Decades As String Dim xTensArr As Variant Dim xOrdArr As Variant Dim xCardArr As Variant xOrdArr = Array(“First”, “Second”, “Third”, _ “Fourth”, “Fifth”, “Sixth”, _ “Seventh”, “Eighth”, “Nineth”, _ “Tenth”, “Eleventh”, “Twelth”, _ “Thirteenth”, “Fourteenth”, _ “Fifteenth”, “Sixteenth”, _ “Seventeenth”, “Eighteenth”, _ “Nineteenth”,… Read more →

Excel formula

Function English(ByVal N As Currency) As String Const Hundred = 100@ Const Thousand = Hundred * 10 Const Lakh = Thousand * 100 Const Crore = Lakh * 100 If (N = 0@) Then English = “zero”: Exit Function Dim Buf As String: If (N > 0@) Then Buf = “(Rupees ” Else Buf = “” Dim Frac As Currency:… Read more →

shopify site analytics