Jan 12, 2005 · I am doing come calculations and end up with 139.7 for example. If I format the cell as a number with no decmial points it automatically rounds up to 140. Normally this is ok, but …

Apr 27, 2004 · Excel 2003: I've got a column of cells. I highlight the entire column, do a format / cells / number then I choose 0 decimal places I have a list of serial numbers that I want to …

060705 Problems: rounding & formatting Text/# combinations is there an answer for, or need for ms to fix: (excerpt from other posting) I believe this to be a Huge problem in excel: not having …

Mar 19, 2008 · The scroll lock seems to come on automatically and becomes stuck. it will not turn off. I have switched keyboards and that does not work. I have also tried detect and repair; this …

Oct 10, 2007 · Can I turn off the AutoCorrect Options in Excel via VBA script? Thanks, Tom

Jan 17, 2006 · For some reason Access is rounding the deliveries that are not whole numbers, so instead of 4.5 it shows 4 etc. The field is a long integer field with a fixed format and decimal …

Sep 27, 2009 · How would I disable rounding up & down in access 2007? e.g. If I multiply 50 * 6.75 = 337.50 but it is rounded up to 338. I want the exact value to be displayed.

Apr 28, 2009 · I am using an IIf statment in my query and the result is rounding the numbers instead of displaying the decimal places. I have tried changing the properties to show one …

Jan 8, 2008 · When I zoom out to smaller than about 40%, the names of the ranges in the sheet get displayed over the top of the data. How do turn these range names off.

Dec 2, 2003 · Is there a way to force Excel to display a slice for every value in a chart, even if the value for the slice is very small - say 0.2%? I'm trying to generate a chart that has 2 slices …