| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
help!! 1000 appears as 10 in excel
When I type 1000 it appears as 10. Can anyone help
|
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
help!! 1000 appears as 10 in excel
Tools|Options|Edit
Un-Check Fixed decimal places Mike "Help!! 1000 appears as 10 in excel" wrote: When I type 1000 it appears as 10. Can anyone help |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
help!! 1000 appears as 10 in excel
ToolsOptionsEdit.
Uncheck "fixed decimal places" Gord Dibben MS Excel MVP On Fri, 25 Apr 2008 06:24:00 -0700, Help!! 1000 appears as 10 in excel <Help!! 1000 appears as 10 in wrote: When I type 1000 it appears as 10. Can anyone help |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| use 100 seperator instead of 1000 in excel | Excel Discussion (Misc queries) | |||
| How change maximal value in excel for filter (1000) ? | New Users to Excel | |||
| 1000+$K$5/1000 -what does $ indicate in formula | Excel Worksheet Functions | |||
| How do I express 1000 in Excel as One thousand? | Excel Discussion (Misc queries) | |||
| if a number is less than -1000 in Excel 2003 | Excel Worksheet Functions | |||
Linear Mode
