1. Computer problem? Tech Support Guy is completely free -- paid for by advertisers and donations. Click here to join today! If you're new to Tech Support Guy, we highly recommend that you visit our Guide for New Members.

Excel Formatting Help...

Discussion in 'Business Applications' started by firstccbank, Feb 10, 2003.

Thread Status:
Not open for further replies.
  1. firstccbank

    firstccbank Thread Starter

    Joined:
    Feb 10, 2003
    Messages:
    14
    I would like to know how to format a cell to change a number to the written out format. (i.e. 5,000 to Five-Thousand). Any ideas?
     
  2. Ziggy1

    Ziggy1

    Joined:
    Jun 17, 2002
    Messages:
    2,551
    I thought the "Text" function might work but I couldn't figure it out for this type of format.

    Follow these instructions found in the "Microsoft KNowledge base" . Copy/paste (not type) the code into a new Module, as instructed. This will make the function available to that workbook , If you put it in the Personal.xls then it will be available as a "User Defined function" (so will the one in workbook).

    I tried it out and it works, you can alter the text to suite your needs.

    If you need help with the code, just ask



    Microsoft Knowledge Base Article - 213360

    http://support.microsoft.com/default.aspx?scid=kb;en-us;213360:) :p


    Ziggy
     
As Seen On
As Seen On...

Welcome to Tech Support Guy!

Are you looking for the solution to your computer problem? Join our site today to ask your question. This site is completely free -- paid for by advertisers and donations.

If you're not already familiar with forums, watch our Welcome Guide to get started.

Join over 733,556 other people just like you!

Loading...
Thread Status:
Not open for further replies.

Short URL to this thread: https://techguy.org/118086

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice