Absolute references

[Mr930]

I have 3 columns of text, and a 4th that concanenates the first 3. Is there a way to globally change the 4th column formulas to be absolute references instead of relative? I want column 4 to point to the same row each time.

thanks
Fred Emmerich

 

[T. Valko]

I have 3 columns of text, and a 4th that concanenates the first 3. Is there a way to globally change the 4th column formulas to be absolute references instead of relative? I want column 4 to point to the same row each time.

thanks
Fred Emmerich

See this...

http://tinyurl.com/6j5e4gu

 

[Mr930]

Perfect! thanks

Fred Emmerich

 

[T. Valko]

Perfect! thanks

Fred Emmerich

You're welcome!