Converting multiple formulas to absolute

[wayne emery]

Please help.

I have a spreadsheet that contains hundreds of simple formulas. For example =+A1.

I need to convert all of these formulae to be absolute. ie =+$A$1. I how to do 1 at a time but can I change a range or a spreadsheet full of them easily?

Many Thanks
Wayne

 

[Andrew Poulsom]

If you are OK with a macro, check out the ConvertFormual method in VBA Help.