+ Reply to Thread
Results 1 to 2 of 2

Input Mask, and putting resulting string into the cell

  1. #1
    Registered User
    Join Date
    09-12-2017
    Location
    Buena Park, CA
    MS-Off Ver
    2010
    Posts
    1

    Input Mask, and putting resulting string into the cell

    So I know my title is weird, but here's what I'm hoping to do.

    I have an input mask applied to an entire column, which is serving as an identifier number for individual people in a sheet. The mask is in the format "FA-#####-##". If I type 1234567 into the cell, the mask applies perfectly, and when looking at the cell on the screen, it shows FA-12345-67. If I click on the cell, and look at the formula bar, it shows the initial input of 1234567. I'm curious, is there a way to be able to type 1234567 into the cell, and have it not only show FA-12345-67 number on the screen, but also modify the cell so it now contains the full thing in the formula bar, and not just the numbers I input? I'm hoping this makes sense, and I'll grab some screenshots if it's needed. Will it take some VB programming to do it, or is there an easier way?

  2. #2
    Forum Expert bebo021999's Avatar
    Join Date
    07-22-2011
    Location
    Vietnam
    MS-Off Ver
    Excel 2016
    Posts
    9,657

    Re: Input Mask, and putting resulting string into the cell

    In fact, it is value to be displayed as text.
    To get the displayed text, try:
    =TEXT(A1,"FA-00000-00")
    with A1 contains value
    Quang PT

+ 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. I want to use an input mask to format cell content
    By OB12OLD in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 01-21-2014, 03:11 PM
  2. [SOLVED] Eliminate data entry key strokes and mistakes in a cell - Input mask? Textlike?
    By JET2011 in forum Excel Formulas & Functions
    Replies: 16
    Last Post: 01-31-2013, 02:50 AM
  3. Replies: 7
    Last Post: 02-25-2011, 03:20 PM
  4. Excel 2007 : Input Mask for Cell Data
    By adzi in forum Excel General
    Replies: 1
    Last Post: 03-21-2009, 05:47 PM
  5. Input Mask
    By HotRod in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-31-2006, 11:38 AM
  6. Cell input mask
    By Dan N in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 03-08-2006, 04:10 PM
  7. Input mask for active cell
    By Lee Hunter in forum Excel General
    Replies: 2
    Last Post: 01-25-2006, 05:00 PM
  8. Can I set an input mask for a cell?
    By Choro in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 02-18-2005, 11:11 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