+ Reply to Thread
Results 1 to 2 of 2

Auto fill matchingl text / number vice versa

  1. #1
    Registered User
    Join Date
    07-06-2012
    Location
    NY
    MS-Off Ver
    Excel 2007
    Posts
    38

    Auto fill matchingl text / number vice versa

    Hi all,

    I want to create a word doc would auto fill matching base on what I type whether it be a number or a text.
    Sort of like a string~ let me explain clearly in a example:

    If I type the word one the following designated area will auto fill the number 1.

    If I type the number 1 the following designated area will auto fill the word one.

    vice versa

    I need to "string" this in word 07 because I am creating a document for clients to fill out and it's to ease the redundancy of them or me typing the number and then the word to that number multiple times.

    Thanks in advance.

  2. #2
    Forum Expert macropod's Avatar
    Join Date
    12-22-2011
    Location
    Canberra, Australia
    MS-Off Ver
    Word, Excel & Powerpoint 2003 & 2010
    Posts
    3,726

    Re: Auto fill matchingl text / number vice versa

    See: http://gregmaxey.mvps.org/word_tip_p...ting_data.html. If you use a formula field for the replication, you can add a CardText picture switch to format its output as text. This will generate the word representing the number's value.
    Cheers,
    Paul Edstein
    [Fmr MS MVP - Word]

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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