| Home |
| Search |
| Today's Posts |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Number automatically divided by 100, why?
perfect!, it works
"FSt1" wrote: hi you have "fixed decimal places" turned on. in xl03, it's toolsoptionsedit tabuncheck fixed decimal places. in xl07, i'm not sure. office buttonexcel options???? snoop around. sorry i could not be more help. i know what the problem is, i just don't have 07 yet. regards FSt1 "Don O'Hara" wrote: When i key a random number into a cell (in MS Excel 2007) the number will automatically divided by 100 for example: if i key in 2000 and press ENTER, it will become 2 immediately if i key in 50 and press ENTER, it will become 0.5 immediately I've checked the data format. the format is "GENERAL". Something wrong with the settings? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Number entered in cell getting always divided by 100 ! | Setting up and Configuration of Excel | |||
| numeric entered automatically divided 100! | Excel Discussion (Misc queries) | |||
| All number inputs are divided by 100 ? | Setting up and Configuration of Excel | |||
| numbers in cells are automatically divided by 100. Not a format s. | Excel Worksheet Functions | |||
| Typed number is always divided by 100 after pressing enter | Excel Discussion (Misc queries) | |||
Threaded Mode
