Dave Peterson wrote:
Format the cell with the formula =CRNo as General. Then hit F2|Enter to reenter
the formula.

Just changing the formatting isn't enough.

ps...

You may want to get Jan Karel Pieterse's (with Charles Williams and Matthew
Henson) Name Manager:

You can find it at:
NameManager.Zip from http://www.oaltd.co.uk/mvp

It'll make working with names much, much easier.

I hadn't seen the MVP site before, very helpful thanks.

However, F2|Enter didn't make any difference :-(