batch convert relative to absolute

[rygo]

Version: 2008
Operating System: Mac OS X 10.5 (Leopard)
Processor: Intel

I have a large group of cells containing formulae with relative cell references (about 300 cells total).

I need to change all of these to absolute cell references.

I could spend hours and CMD+T each one individually. But is there a way to do them as a batch? ie select a whole range and convert all at the same time.

Thanks in advance

 

[Harvey Waxman]

Version: 2008
Operating System: Mac OS X 10.5 (Leopard)
Processor: Intel

I have a large group of cells containing formulae with relative cell
references (about 300 cells total).

I need to change all of these to absolute cell references.

I could spend hours and CMD+T each one individually. But is there a way to do
them as a batch? ie select a whole range and convert all at the same time.

Thanks in advance

Find and Replace in formulas only?

 

[rygo]

Thanks for that, had to do each column separately but worked well.

Feeling like a numwit now!