I need a tip

serickson · Mar 18th, 2002, 01:18 PM

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 · Mar 18th, 2002, 01:26 PM

Quote:

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 · Mar 18th, 2002, 01:29 PM

Quote:

On 2002-03-18 12:26, IML wrote:

Quote:

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.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Mar 18th, 2002, 01:18 PM	#1
serickson Board Regular Join Date: Mar 2002 Location: Denver, Colorado Posts: 61	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.