batch convert relative to absolute

[ry...@officeformac.com]

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]

In article <59b75...@webcrossing.caR9absDaxw>, ry...@officeformac.com
wrote:

Find and Replace in formulas only?

[ry...@officeformac.com]

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

Feeling like a numwit now!