+ Reply to Thread
Results 1 to 6 of 6

Cell format "Text"

  1. 07-18-2017, 05:37 AM #1
    Johan4b is offline
    Registered User
    Join Date
    08-09-2016
    Location
    Atlanta
    MS-Off Ver
    Office 2013
    Posts
    8

    Cell format "Text"

    Hi Guys,

    I have an issue regarding formats and Excel. Is it possible to keep a cell in Excel with the format type "text", even when somebody paste data from word or internetbrowser into this cell.
    I did a little research but didn't find a sollution. I read that it was possible to lock a cell but it doesn't allow you to change the cell value.

    I hope you guys can help me with it.


    Thank you

    Kind regards

    Johan
    Reply With QuoteRegister To Reply
  2. 07-18-2017, 06:09 AM #2
    BellyGas is offline
    Valued Forum Contributor
    Join Date
    03-24-2014
    Location
    England
    MS-Off Ver
    Excel 2003 - 2016
    Posts
    575

    Re: Cell format "Text"

    In the worksheet_change event of the worksheet people are pasting data put code to reset the format of the target cell to text. Use the macro recorder to record yourself changing the format, replace the 'Range' address in the recorded macro with 'Target'.

    Google worksheet_change event for more details.
    Reply With QuoteRegister To Reply
  3. 07-18-2017, 01:48 PM #3
    FDibbins is offline
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    53,049

    Re: Cell format "Text"

    Generally, when data is copied into excel from another app, it comes in as text. Is this not happening for you?
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford
    Reply With QuoteRegister To Reply
  4. 07-18-2017, 01:52 PM #4
    Arkadi is offline
    Forum Expert Arkadi's Avatar
    Join Date
    02-13-2014
    Location
    Smiths Falls, Ontario, Canada
    MS-Off Ver
    Office 365
    Posts
    5,059

    Re: Cell format "Text"

    How about instead of normal paste, use paste special -> paste values?
    Please help by:

    Marking threads as closed once your issue is resolved. How? The Thread Tools at the top
    Any reputation (*) points appreciated. Not just by me, but by all those helping, so if you found someone's input useful, please take a second to click the * at the bottom left to let them know

    There are 10 kinds of people in this world... those who understand binary, and those who don't.
    Reply With QuoteRegister To Reply
  5. 07-18-2017, 02:06 PM #5
    FDibbins is offline
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    53,049

    Re: Cell format "Text"

    Quote Originally Posted by Arkadi View Post
    How about instead of normal paste, use paste special -> paste values?
    OP said they want to keep the TEXT format?
    Reply With QuoteRegister To Reply
  6. 07-18-2017, 02:39 PM #6
    Arkadi is offline
    Forum Expert Arkadi's Avatar
    Join Date
    02-13-2014
    Location
    Smiths Falls, Ontario, Canada
    MS-Off Ver
    Office 365
    Posts
    5,059

    Re: Cell format "Text"

    I just assumed paste values will keep the text format if the cell is formatted as such? I guess from a browser it would not be paste special, but right-click, match destintation formatting
    Last edited by Arkadi; 07-18-2017 at 02:42 PM.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. What's wrong with my this formula "=CELL("contents","D" & TEXT(MATCH(MIN(M25:M39),M25:M39"
    By woshichuanqilz in forum Excel General
    Replies: 4
    Last Post: 06-11-2017, 02:03 PM
  2. [SOLVED] Default cell format is "Date" - I want to change it to "General" - how do I do it globally
    By AGPLily in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 07-16-2015, 10:14 AM
  3. Date format of just "st" "nd" "rd" and "th" with text included
    By notrandom in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 08-10-2013, 05:45 PM
  4. [SOLVED] If there is any text in column "A$" on "sheet1" then move cell to column "A$" on "sheet2"
    By ckgeary in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 06-27-2013, 08:28 PM
  5. [SOLVED] Set default data format to "text" instead of "general"
    By Delta in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 05-04-2012, 02:44 PM
  6. Split cell values based on "," and "-" and format as shown below
    By Roop in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 03-22-2012, 12:28 AM
  7. How to change default cell format to "Text"
    By rbecerra in forum Excel General
    Replies: 2
    Last Post: 09-09-2005, 11:29 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1