All the cells in your worksheet? Well, a quick fix would be Control A to select all cells. Then Alt O and Enter to get to the Format Cells dialog. Then press tab to go into the Numbers dialog box. Press down arrow to currency. I use Accounting as the currency format. Once you locate it, press Enter twice to lock it in. Make sure you deselect, and there it is. All cells in your worksheet are now formatted for currency. Francis -- To post a message to the list, send it to jfw@xxxxxxxxxxxxx To unsubscribe from this mailing list, send a message to jfw-request@xxxxxxxxxxxxx with the word unsubscribe in the subject line.