Second, since all currency symbols are included as standard within the Currency and Accounting number formats in Excel, you don't have to waste time trying to find ways to enter currency symbols ...

Why not format and unlock at the same time by assigning a style ... Click the Review tab and then click Protect Sheet in the Changes group. (In Excel 2003, choose Protect from the Tools menu ...