I need a tip

[serickson]

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.

 

[IML]

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

 

[serickson]

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.