Delete Numbers in Column, Leave Formulas in Column Intact

Discussion in 'Excel Beginners' started by Mike, Jan 3, 2014.

  1. Mike

    Mike Guest

    Is there a quick, easy way to do this?

    Thanks.
     
    Mike, Jan 3, 2014
    #1
    1. Advertisements

  2. Mike

    Claus Busch Guest

    Hi Mike,

    Am Fri, 03 Jan 2014 18:59:19 -0500 schrieb Mike:

    > Is there a quick, easy way to do this?


    no, that is not possible.


    Regards
    Claus B.
    --
    Win XP PRof SP2 / Vista Ultimate SP2
    Office 2003 SP2 /2007 Ultimate SP2
     
    Claus Busch, Jan 4, 2014
    #2
    1. Advertisements

  3. Mike

    Claus Busch Guest

    Hi Mike,

    Am Sat, 4 Jan 2014 08:39:26 +0100 schrieb Claus Busch:

    > no, that is not possible.


    or format the cells custom with ;;;
    If you want see again the result of the formula format "General" or
    "Number"


    Regards
    Claus B.
    --
    Win XP PRof SP2 / Vista Ultimate SP2
    Office 2003 SP2 /2007 Ultimate SP2
     
    Claus Busch, Jan 4, 2014
    #3
  4. Mike

    Claus Busch Guest

    Hi Mike,

    Am Sat, 4 Jan 2014 08:42:44 +0100 schrieb Claus Busch:

    > or format the cells custom with ;;;


    or set font color to white


    Regards
    Claus B.
    --
    Win XP PRof SP2 / Vista Ultimate SP2
    Office 2003 SP2 /2007 Ultimate SP2
     
    Claus Busch, Jan 4, 2014
    #4
  5. Mike

    Claus Busch Guest

    Hi,

    Am Sat, 4 Jan 2014 10:25:18 +0100 schrieb Claus Busch:

    > or set font color to white


    or press CTRL + #


    Regards
    Claus B.
    --
    Win XP PRof SP2 / Vista Ultimate SP2
    Office 2003 SP2 /2007 Ultimate SP2
     
    Claus Busch, Jan 5, 2014
    #5
    1. Advertisements

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments (here). After that, you can post your question and our members will help you out.
Similar Threads
  1. Lee Jeffery

    Loop to compare and delete or leave

    Lee Jeffery, Jul 25, 2004, in forum: Excel Beginners
    Replies:
    4
    Views:
    146
    Lee Jeffery
    Jul 28, 2004
  2. g wills
    Replies:
    4
    Views:
    157
    JulieD
    Dec 3, 2004
  3. AccessNewbie

    leave left column in place as you scroll to the right

    AccessNewbie, Oct 5, 2005, in forum: Excel Beginners
    Replies:
    3
    Views:
    90
    George Gee
    Oct 5, 2005
  4. ojchippy

    Clear contents but leave formulas in Excel

    ojchippy, Apr 23, 2006, in forum: Excel Beginners
    Replies:
    10
    Views:
    233
    David McRitchie
    Jun 16, 2006
  5. Paul
    Replies:
    5
    Views:
    98
  6. justusmomm
    Replies:
    3
    Views:
    149
    Ragdyer
    Aug 26, 2007
  7. jrj19
    Replies:
    2
    Views:
    172
    Gordon
    May 21, 2009
  8. Delete a formula but leave the data.

    , Apr 28, 2014, in forum: Excel Beginners
    Replies:
    2
    Views:
    276
Loading...