View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
YESHWANT JOSHI[_2_] YESHWANT JOSHI[_2_] is offline
external usenet poster
 
Posts: 42
Default 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?