I had the same problem, try this toggle: tools - formula auditing -
formula auditing mode

regards Silvia

Michael wrote:
Any changes I make to the format aren't reflected in the cell. I had to
select worksheet and copy to a new workbook to make changes ... see datachall
post

Thanks