+ Reply to Thread
Results 1 to 2 of 2

How to write a number in words automatically in excel

Hybrid View

  1. 09-19-2014, 11:57 AM #1
    SANKARTUDU
    SANKARTUDU is offline
    Registered User
    Join Date
    03-05-2014
    Location
    INDIA
    MS-Off Ver
    Excel 2007
    Posts
    18

    Arrow How to write a number in words automatically in excel

    If i write "25" in a2 then in b2 write "twenty five " automatically please suggest me a formula sir
    Reply With QuoteRegister To Reply
  2. 09-19-2014, 01:05 PM #2
    ChemistB
    ChemistB is offline
    Forum Guru
    Join Date
    08-05-2004
    Location
    NJ
    MS-Off Ver
    365
    Posts
    13,582

    Re: How to write a number in words automatically in excel

    Take a look at this thread. Use the last VBA Function

    http://www.excelforum.com/excel-gene...ic-values.html
    ChemistB
    My 2?

    substitute commas with semi-colons if your region settings requires
    Don't forget to mark threads as "Solved" (Edit First post>Advanced>Change Prefix)
    If I helped, Don't forget to add to my reputation (click on the little star at bottom of this post)

    Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble
    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 write 20-digits numbers without Excel automatically messing them up?
    By Terminatrix in forum Excel General
    Replies: 15
    Last Post: 04-20-2014, 09:25 AM
  2. Trying to find a way of changing nominal codes into words automatically in excel
    By beckmate4 in forum Excel General
    Replies: 2
    Last Post: 09-11-2012, 10:58 AM
  3. Converting word number in words automatically
    By pio_proenca in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 07-23-2009, 12:54 PM
  4. Automatically define a list of words in Excel?
    By chris in forum Excel General
    Replies: 4
    Last Post: 07-06-2006, 08:10 AM
  5. [SOLVED] how to automatically convert a number to words in Excel
    By Anil-HML in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 11-08-2005, 11:10 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