+ Reply to Thread
Results 1 to 3 of 3

How to express a number in the corresponding value written in words

  1. #1
    Registered User
    Join Date
    09-21-2010
    Location
    Rome, Italy
    MS-Off Ver
    Excel 2003
    Posts
    36

    How to express a number in the corresponding value written in words

    Good morning to everybody.
    I find this forum extremely useful for my daily use of Excel and this my first thread.
    I have this problem: I'm preparing a sort of insurance policy form to be filled on a worksheet and I have to automatically express the figures entered for the sums assured in "sentences".
    In other words, how to convert an amount (i.e € 150,75) in column A in the corresponding expression: "Euro OneHundredFifty/75" in column B.
    Let me say I'm Italian, but I think that if you can suggest a solution in English I can easily transform it in order to write in Italian.
    I thank you in advance for your usual precious assistance.
    Last edited by Romoluzzi; 11-21-2010 at 06:55 AM.

  2. #2
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    20,485

    Re: How to express a number in the corresponding value written in words

    See this KB
    http://support.microsoft.com/kb/213360
    Cheers
    Andy
    www.andypope.info

  3. #3
    Registered User
    Join Date
    09-21-2010
    Location
    Rome, Italy
    MS-Off Ver
    Excel 2003
    Posts
    36

    Re: How to express a number in the corresponding value written in words

    I had no doubt this is the best Excel forum.
    Thank you so much!!!!

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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