When I entered a formula into a cell it stays visible. I have tried several
different styles of format and the only change I have been able to get
resulted in a #ref error. Any ideas would help.

Thanks
Trev