+ Reply to Thread
Results 1 to 9 of 9

Make a cell with a value in it show a Title instead

  1. #1
    Registered User
    Join Date
    09-20-2014
    Location
    Ottawa, Canada
    MS-Off Ver
    2013
    Posts
    21

    Make a cell with a value in it show a Title instead

    I set B22 to equal C14 but I need to format B22 to display "Interest" instead of the value.

  2. #2
    Forum Expert
    Join Date
    09-11-2014
    Location
    Washington, DC
    MS-Off Ver
    2016
    Posts
    1,907

    Re: Make a cell with a value in it show a Title instead

    What is the data currently in C14

  3. #3
    Registered User
    Join Date
    09-20-2014
    Location
    Ottawa, Canada
    MS-Off Ver
    2013
    Posts
    21

    Re: Make a cell with a value in it show a Title instead

    It's 40000

  4. #4
    Forum Guru sktneer's Avatar
    Join Date
    04-30-2011
    Location
    Kanpur, India
    MS-Off Ver
    Office 365
    Posts
    9,655

    Re: Make a cell with a value in it show a Title instead

    Custom format B22 as ;;;"Interest" to show the text Interest in B22 not 40000.
    Is this what you are trying to achieve?
    Regards
    sktneer


    Treat people the way you want to be treated. Talk to people the way you want to be talked to.
    Respect is earned NOT given.

  5. #5
    Forum Expert
    Join Date
    09-11-2014
    Location
    Washington, DC
    MS-Off Ver
    2016
    Posts
    1,907

    Re: Make a cell with a value in it show a Title instead

    If 40000 is the value that you want to prompt the display of "Interest", use this in cell B22:

    Please Login or Register  to view this content.

  6. #6
    Registered User
    Join Date
    09-20-2014
    Location
    Ottawa, Canada
    MS-Off Ver
    2013
    Posts
    21

    Re: Make a cell with a value in it show a Title instead

    Yes! Where do I find Custom format? I have been looking everywhere.. conditional formatting.. format cell... etc.

  7. #7
    Registered User
    Join Date
    09-20-2014
    Location
    Ottawa, Canada
    MS-Off Ver
    2013
    Posts
    21

    Re: Make a cell with a value in it show a Title instead

    I did it! Thank you Sktneer!

  8. #8
    Forum Guru sktneer's Avatar
    Join Date
    04-30-2011
    Location
    Kanpur, India
    MS-Off Ver
    Office 365
    Posts
    9,655

    Re: Make a cell with a value in it show a Title instead

    Right click on B22 --> From the pop up menu select Format Cells --> From Category select Custom --> In the box below Type (you will see General by default) --> Type ;;;"Interest" in the box --> OK.

    Does this help?

  9. #9
    Forum Guru sktneer's Avatar
    Join Date
    04-30-2011
    Location
    Kanpur, India
    MS-Off Ver
    Office 365
    Posts
    9,655

    Re: Make a cell with a value in it show a Title instead

    OK that sounds good. Glad I could help.
    Moreover you may also click on * (star) to Add Reputation if the solution provided helped you. This is another way to say thanks.

+ 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. Show full path title in title bar?
    By Nor in forum Excel - New Users/Basics
    Replies: 5
    Last Post: 04-11-2014, 02:26 PM
  2. Make Chart Title equal to a Cell Value
    By RichardBerry in forum Excel Charting & Pivots
    Replies: 5
    Last Post: 09-13-2007, 08:40 PM
  3. Show sheet title/name in cell
    By age in forum Excel General
    Replies: 4
    Last Post: 01-16-2007, 06:22 AM
  4. [SOLVED] How do I make a cell reference to a sheet title name
    By trtfn in forum Excel General
    Replies: 2
    Last Post: 01-26-2006, 02:45 PM
  5. [SOLVED] how 2 make one cell change title when either of 2 other are > 1
    By confuscious in forum Excel General
    Replies: 6
    Last Post: 08-16-2005, 11:05 AM

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