+ Reply to Thread
Results 1 to 2 of 2

English Word to Numeric digit conversion of numbers- How to do it?

  1. 10-18-2013, 02:11 PM #1
    Dipyaman is offline
    Registered User
    Join Date
    10-18-2013
    Location
    Kolkata
    MS-Off Ver
    Excel 2007
    Posts
    2

    Lightbulb English Word to Numeric digit conversion of numbers- How to do it?

    Hi,

    Is there any formula / macro in excel by which number in English word can be converted into numeric digit ? Eg One Hundred Thirty Five to be converted as 135 . I have not find any solutions of it till date. Pls reply . Dipyaman
    Reply With QuoteRegister To Reply
  2. 10-18-2013, 06:29 PM #2
    mrice is offline
    Forum Expert mrice's Avatar
    Join Date
    06-22-2004
    Location
    Surrey, England
    MS-Off Ver
    Excel 2013
    Posts
    4,967

    Re: English Word to Numeric digit conversion of numbers- How to do it?

    Have a look at this

    http://blog.contextures.com/archives...bers-in-excel/
    Martin
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. How to generate 16 digit unique random alpha numeric numbers?
    By matevijay in forum Excel General
    Replies: 22
    Last Post: 06-27-2024, 10:35 AM
  2. [SOLVED] macro to extract 9 digit numbers as well as alpha numberic 9 digit numbers from txt file
    By Raju Radhakrishnan in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-13-2012, 10:15 AM
  3. digit to word conversion
    By aruncym in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 06-18-2007, 01:16 AM
  4. [SOLVED] how to spellout a digit in english
    By Smart tag in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 07-26-2006, 08:15 AM
  5. Conversion of a Number into English Text
    By Andy Wiggins in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 09-06-2005, 06:05 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1