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
Bookmarks