excel 2007 how to turn off the fixed decimal thing

  • Thread starter Thread starter Edge
  • Start date Start date
Office button>Excel Options>Advanced>Editing Options>uncheck: Automatically
insert a decimal point>OK
 
Office Button > Excel Options > Advanced > Editting Options > cleaar the
automatically insert decimal checkbox
 
hey - thanks but it's off so perhaps i asked the wrong question - i can't
input a numeric value with dot00, example - 175.00 or 1830.00 as when I do it
reads 175 and 1830 - sorry - new to excel
also what is it about iterating references cos I created a formula but it
seems I circled back - i have removed the formula but don't understand what
excel does with it and the crux of the problem
thanks a mil
 
Excel will not display terminating decimal 0s unless you set the format to
do so.

Select the cell(s) in question
Right click>Format Cells>Number tab>Number>set to 2 decimal places>OK

As for your formula problem...it sounds like you created a circular
reference. A circular reference is usually a formula that refers to the
formula itself. For example:

You wan to sum cells in column A and you enter this formula in cell A1:

=SUM(A:A)

That creates a circular reference because the formula is in cell A1 and the
formula =SUM(A:A) includes a reference to cell A1.
 
Back
Top