| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Amount is divided by 100
Hi,
One of my colleagues is having a strange problem: when he types a number in excel 2003, the number is systematically divided by 100. I can't figure out what is going on. Has anyone ever experienced this? Thanks, Kanga |
|
#2
|
|||
|
|||
|
Tools|options|edit tab|Uncheck fixed decimal places.
Kanga wrote: Hi, One of my colleagues is having a strange problem: when he types a number in excel 2003, the number is systematically divided by 100. I can't figure out what is going on. Has anyone ever experienced this? Thanks, Kanga -- Dave Peterson |
|
#3
|
|||
|
|||
|
Probably Tools/Options/Edit tab, Number of Decimal digits is set to +2.
Set it to 0. Regards, Stefi "Kanga" wrote: Hi, One of my colleagues is having a strange problem: when he types a number in excel 2003, the number is systematically divided by 100. I can't figure out what is going on. Has anyone ever experienced this? Thanks, Kanga |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Converting amount in figures to amount in words | Excel Discussion (Misc queries) | |||
| formula to calculate a benefit amount | Excel Discussion (Misc queries) | |||
| Restrict input if amount is exceeded | Excel Worksheet Functions | |||
| How do I calculate Amount of Sales Tax from Total Amount? | Excel Worksheet Functions | |||
| Loan Amortization Template - Amount of Final Payment | Excel Discussion (Misc queries) | |||
Linear Mode
