+ Reply to Thread
Results 1 to 7 of 7

how to convert numeric value to english word?

  1. #1
    Forum Contributor
    Join Date
    09-19-2013
    Location
    chennai
    MS-Off Ver
    Excel 2007
    Posts
    252

    how to convert numeric value to english word?

    Hi,
    I want convert numeric value to English word,
    EXAMPLE

    100 CONVERT TO hundred
    151 convert to ONE FIFTY ONE

    I NEED A FORMULA ONLY, I DON'T NEED VB CODE, PLS HELP ME,

    "=SpellNumber" Function not available in my excel

  2. #2
    Registered User
    Join Date
    09-10-2013
    Location
    indonesian
    MS-Off Ver
    O365
    Posts
    45

    Re: how to convert numeric value to english word?

    maybe you can use this file
    convert.JPG
    Attached Files Attached Files

  3. #3
    Registered User
    Join Date
    01-09-2015
    Location
    US
    MS-Off Ver
    2002
    Posts
    1

    Re: how to convert numeric value to english word?

    Quote Originally Posted by fandi_Damore View Post
    maybe you can use this file
    Attachment 369350
    I have downloaded the file, but couldn't understand how it works. I see correct words for the number "1250.5", but see "#VALUE!" for the number "99999990.5785". Do you know what is the problem?

  4. #4
    Registered User
    Join Date
    09-10-2013
    Location
    indonesian
    MS-Off Ver
    O365
    Posts
    45

    Re: how to convert numeric value to english word?

    type the numeric in column B, and the result in column D,
    could you attach / capture the problem show ("#VALUE!" for the number "99999990.5785)

    conver.PNG

  5. #5
    Registered User
    Join Date
    09-10-2013
    Location
    indonesian
    MS-Off Ver
    O365
    Posts
    45

    Re: how to convert numeric value to english word?

    I think I knowed why your file could be error, cause you used office version 2002, and the file I attached using office version 2010, and the formula in office 2010 version, not available in office 2002 version

    convert error 2.PNG

    convert error.PNG
    Last edited by fandi_Damore; 01-09-2015 at 08:51 AM.

  6. #6
    Registered User
    Join Date
    03-14-2015
    Location
    Azerbaijan
    MS-Off Ver
    ms office 2010
    Posts
    6

    Re: how to convert numeric value to english word?

    hi i tried spellnumber function in eglish it is ok
    but i need this function in azerbaijanian language
    it is very necessary can anyone help me?
    1- bir
    2- iki
    3- üç
    4- dörd
    5- beş
    6- altı
    7- yeddi
    8- səkkiz
    9- doqquz
    10- on
    11- on bir
    12- on iki
    13- on üç
    14- on dörd
    15- on beş
    16- on altı
    17- on yeddi
    18- on səkkiz
    19- on doqquz
    20 - iyirmi
    30 - otuz
    40- qırx
    50- əlli
    60- altmış
    70- yetmiş
    80- səksən
    90- doxsan
    100- yüz
    1000- min
    million- milyon
    billion- milyard
    trillion- trilyard
    currency manat qəpik
    dollar- manat
    cent- qəpik

  7. #7
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    53,048

    Re: how to convert numeric value to english word?

    manutd275

    Unfortunately your post does not comply with Rule 2 of our Forum RULES. Do not post a question in the thread of another member -- start your own thread.

    If you feel an existing thread is particularly relevant to your need, provide a link to the other thread in your new thread.

    Old threads are often only monitored by the original participants. New threads not only open you up to all possible participants again, they typically get faster response, too.
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. English Word to Numeric digit conversion of numbers- How to do it?
    By Dipyaman in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-18-2013, 06:29 PM
  2. convert number to english word
    By mimzkie1101 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 09-10-2012, 05:41 AM
  3. How to convert numeric values from English to French?
    By quikgun15 in forum Excel General
    Replies: 3
    Last Post: 07-14-2010, 03:44 PM
  4. convert numeric to word
    By MRIDUL in forum Excel General
    Replies: 1
    Last Post: 07-17-2006, 12:05 PM
  5. [SOLVED] How to convert english word to pronoun in excel?
    By nath in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 03-13-2006, 12:55 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1