+ Reply to Thread
Results 1 to 4 of 4

How to input text into a cell without the text function

  1. #1
    Registered User
    Join Date
    01-12-2012
    Location
    Orlando, FL
    MS-Off Ver
    2010
    Posts
    46

    How to input text into a cell without the text function

    I inherited a spreadsheet from another employee and there is a cell in the spreadsheet that appears empty but when I type a number into it, it always returns that number with the word "Days" next to it. IE....I enter "300"....."300 Days" shows up in the cell. The cell can be used as if only 300 were in it...IE...it will calculate as part of another formula or function.

    How did the other employee do this?

    Thanks

  2. #2
    Registered User
    Join Date
    01-12-2012
    Location
    Orlando, FL
    MS-Off Ver
    2010
    Posts
    46

    Re: How to input text into a cell without the text function

    Nevermind, I figured it out. He used a custom format in that cell.

    Thanks

  3. #3
    Valued Forum Contributor
    Join Date
    02-07-2013
    Location
    Philippines
    MS-Off Ver
    Excel Online; 365
    Posts
    633

    Re: How to input text into a cell without the text function

    check the formatting applied to the cell. RIght click the cell > Format Cells

    ex: ### "Days"
    If I've helped U pls click on d *Add Reputation

  4. #4
    Forum Guru AlKey's Avatar
    Join Date
    07-20-2009
    Location
    Lakeland, FL USA
    MS-Off Ver
    Microsoft Office 2010/ Office 365
    Posts
    8,903

    Re: How to input text into a cell without the text function

    It is the Custom formatting of the cell that does it. So I you click on one of those cell and go to cell formatting you will how the is formatted.
    If you like my answer please click on * Add Reputation
    Don't forget to mark threads as "Solved" if your problem has been resolved

    "Nothing is so firmly believed as what we least know."
    --Michel de Montaigne

+ 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. [SOLVED] If a cell has text then input text into another, unless there is text in there already
    By papasmurfuo9 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 11-27-2013, 10:57 AM
  2. [SOLVED] Leave text in a cell when same cell has no text input.
    By rastak1 in forum Excel General
    Replies: 9
    Last Post: 07-12-2013, 12:51 AM
  3. [SOLVED] nested if function trying to find text and return text in different cell
    By shelbyleighh in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 06-14-2013, 12:16 PM
  4. Format text in a cell with TEXT function.
    By Shodaar in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 08-30-2012, 10:57 AM
  5. [SOLVED] How to input additional text to multiple of existing cells that has text
    By RagDyer in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 09-06-2005, 10:05 AM
  6. [SOLVED] How to input additional text to multiple of existing cells that has text
    By RagDyer in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 09-06-2005, 07:05 AM
  7. [SOLVED] How to input additional text to multiple of existing cells that has text
    By tngo@hotmail.com in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 03:05 AM
  8. How to input additional text to multiple of existing cells that has text
    By tngo@hotmail.com in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 01: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