Excel - Changing the way a number is "rounded" and "fractioned"
Posted on 1998-03-15
Three questions I need answered:
1) How can I control the way the program averages a number up or down? Example: If I enter 12.75, it will average it up to 12.80......Which I do not want.
2) How can I control the way the program shows a fraction? Example: If a calculated number comes to 6.5976, I would prefer it only giving me 6.6
3) Lets say I have a workbook that I use daily and there are some cells that I do not care to ever change or have changed, Is there a way to "lock" these cells?
THANK YOU VERY MUCH FOR ANY HELP YOU CAN PROVIDE!!!