+ Reply to Thread
Results 1 to 4 of 4

Converting numbers to letters

  1. #1
    Registered User
    Join Date
    07-01-2017
    Location
    Bahrain
    MS-Off Ver
    micro soft excel 2017
    Posts
    9

    Converting numbers to letters

    Good day every one,

    I wonder if it is possible in excel to convert or write in letters in an cell address for an amount in figures which is in a different cell address.

    e.g. 2550.000 in A1
    converted Two Thousand Five Hundred Fifty in A2

    This is used to write receipts or invoices or checks.

    If possible please advise how.

    Thanks for your help

    Khalid Al Awadhi
    Last edited by alansidman; 09-20-2017 at 08:47 AM.
    Khalid

  2. #2
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 Version 2404 Win 11 Home 64 Bit
    Posts
    23,860

    Re: Converting numbers to letters

    This is an often asked question on Excel forums. Here is a link to one solution

    https://answers.microsoft.com/en-us/...08f3ea5?auth=1

    BTW: I have removed your email address from the post. Unless you like receiving spam messages, you should never post your email address in an active forum. Spammers troll forums looking for valid email addresses.
    Alan עַם יִשְׂרָאֵל חַי


    Change an Ugly Report with Power Query
    Database Normalization
    Complete Guide to Power Query
    Man's Mind Stretched to New Dimensions Never Returns to Its Original Form

  3. #3
    Forum Expert dominicb's Avatar
    Join Date
    01-25-2005
    Location
    Lancashire, England
    MS-Off Ver
    MS Office 2000, 2003, 2007 & 2016 365
    Posts
    4,867

    Re: Converting numbers to letters

    Good afternoon Khalid Al Awadhi

    Try this article out. It gives step-by-step instructions on the matter.

    HTH

    DominicB

  4. #4
    Registered User
    Join Date
    07-01-2017
    Location
    Bahrain
    MS-Off Ver
    micro soft excel 2017
    Posts
    9

    Re: Converting numbers to letters

    Thank you very much Alan for your warning and removing my Email, I appreciated it.

    and thanks for the link.

    Khalid

+ 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. Converting Letters to Numbers
    By KeanuB in forum Excel Formulas & Functions
    Replies: 28
    Last Post: 09-28-2016, 11:19 AM
  2. [SOLVED] Converting Numbers to Letters
    By PTMD in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 11-27-2015, 10:35 PM
  3. converting letters to numbers
    By pearc in forum Excel Formulas & Functions
    Replies: 22
    Last Post: 02-13-2014, 12:34 PM
  4. converting letters to numbers
    By needexcelhelptoday in forum Excel Formulas & Functions
    Replies: 17
    Last Post: 05-21-2013, 10:55 AM
  5. converting letters to numbers
    By mastertechs in forum Excel General
    Replies: 3
    Last Post: 05-09-2013, 01:55 AM
  6. Converting numbers to letters
    By jolumbo in forum Excel General
    Replies: 3
    Last Post: 12-05-2006, 11:34 AM
  7. converting letters to numbers
    By trav in forum Excel General
    Replies: 9
    Last Post: 02-20-2006, 06:40 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