clear CELL "@" format
 

Cannot clear @ formate entered in a cell by mistake.

clear CELL "@" format
 

What format do you want to have? You can't simply have no format, it either a
specified format or general (type "General", sans quotes).
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"neville" wrote:

Cannot clear @ formate entered in a cell by mistake.

clear CELL "@" format
 

1. remove any protection from workbooks and worksheets
2. unlock all cells
3. click on the cell(s) and:

Edit Clear Formats
--
Gary''s Student - gsnu200907