Hi,

When I change a bunch of numbers to text format it doesn't work straight
away. I need to edit each number (F2) to kick in the change and then the
format seems to stick. I'm using Excel 2003.

When I used IsText function it said false until I edited each cell and
pressed enter.

I'm having to do this for each cell. Please help.

Any help greatly appreciated.

Thanks

Suzanne