I am making a sheet with a column that is going to be filled with different fractions that are input by the user. For example, 1 23/32, 2 1/4, 4 1/8, etc.

For whatever reason, when I type in 1 23/32, Excel decides to round it up to 2. I do not want it rounded, I want it to be exactly as I type it.


My 2nd problem is that sometimes, the numbers I type in aren't centered. I click on the cell, and select center justification, but it still seems offset from the center a bit. I type in something like 2 and it will not be centered.

Anyone who can help, I would appreciate it.


Windows XP
Excel 2000