Hi,

I've started a new workbook, and have my cells formatted to Currency, 0 decimal places, $ symbol.

On every worksheet, 1000 becomes $1,000, but 500 becomes $5 in every cell in that column.

The same thing happens if I format the cells as Number and Accounting.

What gives?

Nancy