text format doesn't work properly
"Grd" wrote in message ...
| 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
|