Easy Office
LCI Learning


Bhanu Pratap Singh
09 August 2022 at 13:26

Spellnumber

If we enter a number it will convert into individual strings and display in same order.

Ex: If I enter 564 then the output should be FIVE SIX FOUR.

So can anyone modify this code to get this result.



Function SpellNumber(amt As Variant) As Variant

Dim FIGURE As Variant
Dim LENFIG As Integer
Dim i As Integer
Dim WORDs(19) As String
Dim tens(9) As String
WORDs(1) = "ONE"
WORDs(2) = "TWO"
WORDs(3) = "THREE"
WORDs(4) = "FOUR"
WORDs(5) = "FIVE"
WORDs(6) = "SIX"
WORDs(7) = "SEVEN"
WORDs(8) = "EIGHT"
WORDs(9) = "NINE"
WORDs(10) = "TEN"
WORDs(11) = "ELEVEN"
WORDs(12) = "TWELVE"
WORDs(13) = "THIRTEEN"
WORDs(14) = "FOURTEEN"
WORDs(15) = "FIFTEEN"
WORDs(16) = "SIXTEEN"
WORDs(17) = "SEVENTEEN"
WORDs(18) = "EIGHTEEN"
WORDs(19) = "NINETEEN"
tens(2) = "TWENTY "
tens(3) = "THIRTY "
tens(4) = "FOURTY "
tens(5) = "FIFTY "
tens(6) = "SIXTY "
tens(7) = "SEVENTY "
tens(8) = "EIGHTY "
tens(9) = "NINETY "
FIGURE = amt
FIGURE = Format(FIGURE, "FIXED")
FIGLEN = Len(FIGURE)
If FIGLEN 1 Then
ElseIf Val(Left(FIGURE, 9)) = 1 Then
End If
For i = 1 To 3
If Val(Left(FIGURE, 2)) 0 Then
SpellNumber = SpellNumber & WORDs(Val(Left(FIGURE, 2)))
ElseIf Val(Left(FIGURE, 2)) > 19 Then
SpellNumber = SpellNumber & tens(Val(Left(FIGURE, 1)))
SpellNumber = SpellNumber & WORDs(Val(Right(Left(FIGURE, 2), 1)))
End If
If i = 1 And Val(Left(FIGURE, 2)) > 0 Then
SpellNumber = SpellNumber & " CRORE "
ElseIf i = 2 And Val(Left(FIGURE, 2)) > 0 Then
SpellNumber = SpellNumber & " LAKH "
ElseIf i = 3 And Val(Left(FIGURE, 2)) > 0 Then
SpellNumber = SpellNumber & " THOUSAND "
End If
FIGURE = Mid(FIGURE, 3)
Next i
If Val(Left(FIGURE, 1)) > 0 Then
SpellNumber = SpellNumber & WORDs(Val(Left(FIGURE, 1))) + " HUNDRED "
End If
FIGURE = Mid(FIGURE, 2)
If Val(Left(FIGURE, 2)) 0 Then
SpellNumber = SpellNumber & WORDs(Val(Left(FIGURE, 2)))
ElseIf Val(Left(FIGURE, 2)) > 19 Then
SpellNumber = SpellNumber & tens(Val(Left(FIGURE, 1)))
SpellNumber = SpellNumber & WORDs(Val(Right(Left(FIGURE, 2), 1)))
End If
FIGURE = Mid(FIGURE, 4)
If Val(FIGURE) > 0 Then
SpellNumber = SpellNumber & " PAISE "
If Val(Left(FIGURE, 2)) 0 Then
SpellNumber = SpellNumber & WORDs(Val(Left(FIGURE, 2)))
ElseIf Val(Left(FIGURE, 2)) > 19 Then
SpellNumber = SpellNumber & tens(Val(Left(FIGURE, 1)))
SpellNumber = SpellNumber & WORDs(Val(Right(Left(FIGURE, 2), 1)))
End If
End If
FIGURE = amt
FIGURE = Format(FIGURE, "FIXED")
If Val(FIGURE) > 0 Then
SpellNumber = SpellNumber & " ONLY "
End If
End Function

Answer now

Abhishek Gupta

I work for a MNC in India which has it's stock listed on NASDAQ in USA. I get RSUs of the US stock as a part of my compensation (listed under perquisites in form 16).

Scenario:

Note that my mother, father and the HUF have almost no income.

I gift "x" amount of those vested stocks to mother, "y" amount to my father and "z" amount to my father's HUF.

Assumptions/Understanding:

(1) These gift transactions would not trigger any tax payment at both ends (giver and receiver) as they are exempted relatives.

(2) Given this transaction happens electronically (from my trading account to the receiver's trading account), a record is always available of this transaction so a Gift Deed is not required.

(3) Since the gift is not given to the spouse here so clubbing provision don't apply here.

(4) NASDAQ listed equity is counted as unlisted shares and STCG at tax slab is applied for sale under 24 months, LTCG at 20% with indexation after 24 months applies.

(5) The cost and date of acquisition of the gifted stock in the receiver's hand would be the same as me (the giver).

(6) If my mother sells "x" amount of stocks within 24 months of the date of acquisition (not gifting), STCG would apply on the profit derived from "x" amount of stocks (sale price - cost of acquisition) as a part of her normal income as per her tax slab. And given her income is almost negligible that profit (upto a max of 10 lakhs) gets taxed at a rate much lower than 34.32% (had I sold them, I would have paid at 34.32% or had I waited for LTCG to kick in, 20% with indexation benefit). Is this understanding correct?

Answer now

B K D
05 August 2022 at 12:41

Compensation ..

i am director in a company since Dec 2016 with stock options and salary . my company is getting closed but my compensation has not been paid since 4 years and the top management is not responding to my claims . Where and how can i claim or complaint as per the legal procedures ..

Answer now

Sri ram

As per Rule, any value of gift received higher than Rs 50K become taxable under the section 56. (Lets assume not through relatives) if it is declared by the receiver does it get exempted to the person who gifts the same? if not allowed, will it not become double taxation in the hands of receiver, if his income falls in income tax slabs?

Answer now

kollipara sundaraiah
02 August 2022 at 20:12

Itc question for gst

Sir,
A Gst registered Regular scheme dealer itc excess claim notice received from gst department difference between gstr3b vs gstr2a/gstr2b previous years:18-19,19-20,20-21 years total excess itc claim rs:8 lacs.if dealer itc claim orginal invoice based input show in gstr3b return filed every month
Question:
Dealer itc claim excess previous years notice show amount tax pay compulsory.

Answer now

md shakil

I have got a case of NGO audit and submission of return for 5 years (WB).

I am unable to understand that how should I submit all audited documents at a time at e-district portal of west Bengal.

Pl advice

Answer now

Kritka Jain

Good Morning Sir,
I have a query.
Recently Gov. notified that residential dwelling will no more be exempted and the registered party has to pay gst under RCM
A company i.e. STARKE INDUSTRIES is registered in Karnataka and they pay lease / rent for their employees residing at UP ( Please note right now company is not registered in UP)
Query 1 :- If immovable property is located in a 'state where STARKE INDUSTRIES is not registered' i.e. in UP and location of supplier (LOS) is also in such state i.e. UP then CGST and SGST is required to pay being an intra state supply. So how liability of CGST and SGST would be paid while company is not registered in such state? Or company will pay IGST? kindly tell the section which need to be gone through
Query 2: - If immovable property is located in a 'state where STARKE INDUSTRIES is not registered' i.e. UP and location of supplier is in MP. Then what will be levied i.e. whether IGST or CGST & SGST
Kindly have a look at the queries I will be highly obliged.

Answer now

keyur
01 August 2022 at 08:59

10 E form not e verified yet

Sir/Madam

Two days before i was tried to submit 10E for getting relief of arrear salary received during 2021-22. Mobile no is not linked with my adhar card so OTP is not generated. So 10 E form not successfully submitted online. I summited ITR V on the same day.

What to do for form 10E?? Can i will take printout and submit with ITR V at Bangalore Office??
Is any option to generate OTP.? Netbaking is not possible and OTP generate through ATM machine, i tried it but option is not found out.

Please guide me at earliest.

Answer now

Pradeep Jain
29 July 2022 at 15:28

Can i file itr-1

if i have 215000 income as interest can i file itr form 1 & till what amt i can file form itr -1

Answer now

Anubhav

Its more of a academic query. I recently came across income tax computation of a person where his professional friend had attempted to show most of his receipts of income as hand loan thereby trying to avoid tax on genuine income. Now I was wondering what are the ways through which Income Tax department would ensure that such an assessee cannot escape taxation. Also can you point out ways through which this kind of tax avoidance method would fail ?

Answer now