I have tried the above it will not work if I put sting staing that if cell =
zero enter space" " however it does work if I tap in space bar. any ideas is
my excel corrupt?