open excel then press Alt+F11.
then choose module from insert menu.
then paste all code wat i have noted u in the page.
then save the visual basic editor and close
the the function is =value(1234) (for the number directly)
or value(D4) (for any cell 's value.
U r welcome
On 7/21/09, Nandkumar
Hi
I thought converting to numbers to text using formulas much better
than using macros because if you use macros:
1) You will need to enable macros
2) If you use an add-in, that formula doesn't work when you copy that
file to another computer where the add-in is not installed
I have prepared a
Hello,
Plse tell how to work
Pls tell me step
Thanks in advance
On Tue, Jul 21, 2009 at 10:55 AM, Pranaya Pradhan wrote:
> TRY THIS ONE
>
>
> Function SpellNumber(ByVal MyNumber, Optional incRupees As Boolean = True)
> Dim Crores, Lakhs, Rupees, Paise, Temp
> Dim DecimalPlace As Long, Count As
TRY THIS ONE
Function SpellNumber(ByVal MyNumber, Optional incRupees As Boolean = True)
Dim Crores, Lakhs, Rupees, Paise, Temp
Dim DecimalPlace As Long, Count As Long
Dim myLakhs, myCrores
ReDim Place(9) As String
Place(2) = " Thousand ": Place(3) = " Million "
Place(4) = " Billion ": Place(5) =
Hi Vikas
This request was posted earlier by one of our friends. Heres the macro to
convert numbers into words.
Sub SetNums()
Numbers = Array("", "One", "Two", "Three", "Four", "Five", "Six", "Seven",
"Eight", "Nine", "Ten", "Eleven", "Twelve", "Thirteen", "Fourteen",
"Fifteen", "Sixteen", "Sevent
