Ask Experts Questions for FREE Help !
Ask
    thegreatwolf's Avatar
    thegreatwolf Posts: 1, Reputation: 1
    New Member
    		  
    #1

    Jan 20, 2011, 05:49 AM
    excel digits convert into text?
    I just want to know that if I enter some value like "1000"
    it can b change into text form like "one thousand"
    if there is any formula *** tell me
    this is my mailing address >Removed<
    JBeaucaire's Avatar
    JBeaucaire Posts: 5,426, Reputation: 997
    Software Expert
    		  
    #2

    Jan 20, 2011, 08:29 AM

    No there is no built-in Excel function to convert numbers to word-text. You can add that functionality in.

    Here's a page that offers a User-Defined-Function call SpellNumber that you can install into your workbook and use.

    Excel: Convert Numbers to Words/Text

    If you Google: converting excel numbers to text you'll tons more just like it. This isn't an uncommon desire.
Not your question? Ask your question View similar questions
 

Question Tools Search this Question
Search this Question:

Advanced Search

Add your answer here.


Check out some similar questions!

Excel 15 digit issue, tried converting to text, text to column feature negates fix [ 6 Answers ]

I have the following numbers that exceed 15 characters that needs to be split into its own columns. Down the road, there would be thousands of such rows of data with the first couple set of unique numbers. 890432453253208820,5004500558,05CC,1,0,0,0,0,0,0, 0000,5.0000,2007-01-11...

How many 4 digits number formed of only odd digits are divisible by five [ 3 Answers ]

How many 4 digits number formed of only odd digits are divisible by five

Excel text formula [ 2 Answers ]

Hi, Please provide me the formula to convert names in to email address, for example - "William Smith" should be converted in to "[email protected]. Thanks in advance

Convert image (pdf, typewriter text) to text file [ 21 Answers ]

I've played with 3 different OCR apps (including one that seems to be tops (Abbyy Fine Reader Pro) and find it too much. Easy to use but far too time consuming for my skills with it. See the attached pdf (38 pages of typed text). I have it and 5 others that need converted but am finding it too...

View more questions Search