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 in this case I …

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 input, and then …

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 a check box, …

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 decimal place, but it …

Aug 9, 2004 · Hello, I have a field on my form which will be used for entering dollar amounts but when a number such as 374.45 is keyed in.....it automatically converts to round it off to 374.00.This …

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.

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

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 sometimes …

Jun 13, 2005 · When using excel, viewing the same worksheet in two windows, sometimes the navigation is syncronised in both, and sometimes not. This prevents me looking at different parts of …

Apr 7, 2005 · I just started using access created table with number fields. Set the number fields to long integer, fixed 2 decimal places. Everytime I put a number in it round up or down and I see XXX.00 in …