Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I change default number format?
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? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I change default number format?
But how do I change the basic format back to default? This is an enormous
spreadsheet with tons of different formatting, so its a little bit complicated selectively format everything back to the general number format. I have been working with this spreadsheet for months and it was completely normal, but the default number format changed shortly after I switched from Excel 2003 to Excel 2007. There has to be some way to switch it back. "YESHWANT JOSHI" wrote: 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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Is it possible to change the default number format in Excel? | Excel Discussion (Misc queries) | |||
Change Default Number Format | Excel Discussion (Misc queries) | |||
How do I change the default number format ? | Excel Discussion (Misc queries) | |||
How do I change the default number format in excel? | Excel Worksheet Functions | |||
How do I change the default number format? | Excel Discussion (Misc queries) |