How do I change default number format?
hi dwayne1017,
it seems that the entire workbook on which u r working has been formatted as
currency . first, select the cells u want to give input, format them as
numbers (with or without decimals) and then re-enter the data (because
entering the text first and then chaning the format of cell/s does not work
properly in excel sometimes).
hope this will work for u.
if it works, click yes
"dwayne1017" wrote:
For some reason, every number that I enter in a certain workbook defaults to
Puerto Rican dollars, rather than the general number format. When I remove
formats on a cell, the cell also becomes Puerto Rican dollars. How do I
revert back to the standard unformatted input?
|