I need a tip
Amazing chart utilities from Jon Peltier
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 3 of 3

Thread: I need a tip

  1. #1
    Board Regular
    Join Date
    Mar 2002
    Location
    Denver, Colorado
    Posts
    61
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

     
    somebody has to have a shortcut for me.

    I have a column that contains both values and calculations. I want a quick way to zero out the values, yet leave the calculations.

    In 123 I used to be able to /file combine subtract values. It left the calculations alone and subtracted the values from themselves to leave zero.

    any help?

    thanks.

  2. #2
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Denver, CO
    Posts
    1,743
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    On 2002-03-18 12:18, serickson wrote:
    somebody has to have a shortcut for me.

    I have a column that contains both values and calculations. I want a quick way to zero out the values, yet leave the calculations.

    In 123 I used to be able to /file combine subtract values. It left the calculations alone and subtracted the values from themselves to leave zero.

    any help?

    thanks.
    Highlight your range, Hit control G, special Constants and delete.

    good luck

  3. #3
    Board Regular
    Join Date
    Mar 2002
    Location
    Denver, Colorado
    Posts
    61
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

      
    On 2002-03-18 12:26, IML wrote:
    On 2002-03-18 12:18, serickson wrote:
    somebody has to have a shortcut for me.

    I have a column that contains both values and calculations. I want a quick way to zero out the values, yet leave the calculations.

    In 123 I used to be able to /file combine subtract values. It left the calculations alone and subtracted the values from themselves to leave zero.

    any help?

    thanks.
    Highlight your range, Hit control G, special Constants and delete.

    good luck
    Perfect!

    thank you very much.

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

 

 
DMCA.com