Search : in
By :

How to convert a numeric value into eng. word

Last answer on Oct 23, 2009 6:16:54 am BST raj86, on May 9, 2009 5:30:26 pm BST 
 Report this message to moderators

Hello,
How to convert a numeric value into English words in Excel plz show that formula

Configuration: Windows XP
Safari 525.19

Best answers for « How to convert a numeric value into eng. word » in :
Formula for conveting numerical value into wo Show
How to convert a numeric value into english Word? Show How to convert a numeric value into english Word? To convert a numeric value into eng. Word, here is the formula you will need This is a post from the forum, thanks to rajput391 Below code enter in excel sheet: 1. Press Alt+F11 >...
Convert xbox 360 into a vista O.S. Show
Converting your PDF file into an Image ShowConverting your PDF file into an Image Universal Document Converter PDF2IMAGE PDF TO IMAGE CONVERTER You could have encountered difficulties to modify PDF docs in the past. Nowadays this is no more trouble as there are several PDF...
How to convert Excel into PDF? ShowHow to convert Excel into PDF? Here is a small tips about how to convert your excel files into PDF for your presentation. Step 1 PDF995 is software that gets installed on your computer which enables you to print any sources of document to...
Converting VHS into a digital format ShowConverting VHS into digital format Digititalize your VHS tapes without capture card You have some video tapes that are precious to you and don't want to lose them.Then better sotre them in a Digital format. In this tip, we...
Download Free Word/Doc Txt to Image Jpg/Jpeg Bmp Tiff Png ShowIt is usually the images that we insert into Word, Excel or PowerPoint documents. This time, it is the opposite, because we are going to convert these documents to image formats. All to Jpg / JPEG Image Bmp Tiff Png Converter is a powerful tool which...
Download Quick Word to PDF ShowTo transfer your documents most in possible security, there is not better than format PDF. Then, to convert your documents Word into PDF, adopt the quick program Word to PDF. Quick Word to PDF is a tool which integrates with the interface of...
Download Free PDF to Word Converter ShowDocuments PDF are certainly most on and the most stable for transfers, since they cannot be changed. However, sometimes they need data contained in a document PDF which they would like to edit or to change. Free PDF to Word Converter is as name...
IP Address ShowWhat is an IP address? Computers communicate over the Internet using the IP protocol (Internet Protocol), which uses numerical addresses, called IP addresses, made up of four whole numbers (4 bytes) between 0 and 255 and written in the format...
Binary encoding ShowIntroduction to binary In the late 1930s, Claude Shannon showed that by using switches which were closed for "true" and open for "false," it was possible to carry out logical operations by assigning the number 1 to "true" and 0 for "false." This...
Spreadsheets - Data Entry ShowCell Content A cell of a worksheet can contain a value or be empty. The value of a cell has two essential characteristics: a type, which means the intrinsic type of the data. There are generally three types of values: numeric values, for example...
Ask your question Reply

1

dolphy, on Jun 4, 2009 9:00:05 am BST
  • +12

Kindly mail me the formula to convert numeric value into english words in indian system in Microsoft Excel 2007

   
Reply to dolphy

10

mahesh makwana, on Oct 10, 2009 11:29:12 am BST
  • +7

What is the formula to convert number into text/word in excel.

   
Reply to mahesh makwana

11

valendra, on Oct 16, 2009 3:53:38 am BST
  • +3

How to convert a numeric value into eng. word

   
Reply to valendra

13

 TRIPATHI, on Oct 23, 2009 6:16:54 am BST
  • +3

Pls provide me the software to convert digit into english word

   
Reply to TRIPATHI

2

sandesh, on Jul 9, 2009 1:54:34 pm BST

Hi

pls mail me the formula to convert numerical figure into words for eg (10 to ten)

pls do the needful

sandesh

   
Reply to sandesh

7

bala, on Sep 9, 2009 11:02:27 pm BST

Please e-mail formular - how to convert a numeric value into eng.words
e.g 10 to ten

thanks & regard

   
Reply to bala

3

SANDEEP, on Jul 16, 2009 10:52:00 am BST
  • +2

How to convert a numeric value into eng. word

   
Reply to SANDEEP

5

Raj, on Aug 4, 2009 9:48:39 am BST
  • +3

Do we have any option to convert any numeric value to convert into words in MS Word. For eg. 450 four hundred and fifty, like this?

   
Reply to Raj

12

kana, on Oct 22, 2009 6:02:21 am BST
  • +1

Dear Sir

I want to convert a numeric value into English word in Excel sheet


please tell me formula in Excel format

   
Reply to kana

8

pradeep, on Sep 17, 2009 5:45:17 am BST
  • +1

Hi

I want to know the formula, how can I convert a numeric value into english word in open office.org.

Thanks,
Pradeep

   
Reply to pradeep

4

Yogesh, on Jul 17, 2009 11:43:52 am BST
   
Reply to Yogesh

6

rajput391, on Sep 6, 2009 12:10:50 pm BST
  • +3

Hi.

Below code enter in excel sheet
1. Press Alt+F11 > copy and pate in module (if module not show the insert module click insert on menu bar > Module)
2. Alt+Q Save code and return on Excel sheet
3. Insert > function > user defined > A1 or (relevent cell)

Function words(fig, Optional point = "Point") As String
Dim digit(14) As Integer
alpha = Array("", "One", "Two", "Three", "Four", "Five", "Six", "Seven", "Eight", "Nine", "Ten", "Eleven", "Twelve", "Thirteen", "Fourteen", "Fifteen", "Sixteen", "Seventeen", "Eighteen", "Nineteen", "Twenty", "Thirty", "Forty", "Fifty", "Sixty", "Seventy", "Eighty", "Ninety")
figi = Trim(StrReverse(Str(Int(Abs(fig)))))
For i = 1 To Len(figi)
digit(i) = Mid(figi, i, 1)
Next
For i = 2 To Len(figi) Step 3
If digit(i) = 1 Then
digit(i) = digit(i - 1) + 10: digit(i - 1) = 0
Else: If digit(i) > 1 Then digit(i) = digit(i) + 18
End If
Next
For i = 1 To Len(figi)
If (i Mod 3) = 0 And digit(i) > 0 Then words = "hundred " & words
If (i Mod 3) = 1 And digit(i) + digit(i + 1) + digit(i + 2) > 0 Then _
words = Choose(i / 3, "thousand ", "million ", "billion ") & words
words = Trim(alpha(digit(i)) & " " & words)
Next
If fig <> Int(fig) Then
figc = StrReverse(figi)
If figc = 0 Then figc = ""
figd = Trim(WorksheetFunction.Substitute(Str(Abs(fig)), figc & ".", ""))
words = Trim(words & " " & point)
For i = 1 To Len(figd)
If Val(Mid(figd, i, 1)) > 0 Then
words = words & " " & alpha(Mid(figd, i, 1))
Else: words = words & " Zero"
End If
Next
End If
If fig < 0 Then words = "Negative " & words
End Function



FROM :-
rajput391@yahoo.com
+923336904099

   
Reply to rajput391

9

trek, on Sep 23, 2009 8:25:42 pm BST
  • +2

Do you have to put this formula in every time a new file opened or is it saved somewhere?

Thanks

   
Reply to trek
Ask your question Reply
They need your help