Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
excel 2007 how to turn off the fixed decimal thing
-- Edge |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
excel 2007 how to turn off the fixed decimal thing
Office buttonExcel OptionsAdvancedEditing Optionsuncheck: Automatically
insert a decimal pointOK -- Biff Microsoft Excel MVP "Edge" wrote in message ... -- Edge |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
excel 2007 how to turn off the fixed decimal thing
Office Button Excel Options Advanced Editting Options cleaar the
automatically insert decimal checkbox -- Gary''s Student - gsnu200907 "Edge" wrote: -- Edge |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
excel 2007 how to turn off the fixed decimal thing
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 -- Edge "Edge" wrote: -- Edge |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
excel 2007 how to turn off the fixed decimal thing
Excel will not display terminating decimal 0s unless you set the format to
do so. Select the cell(s) in question Right clickFormat CellsNumber tabNumberset to 2 decimal placesOK 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. -- Biff Microsoft Excel MVP "Edge" wrote in message ... 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 -- Edge "Edge" wrote: -- Edge |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Fixed decimal places in Excel | Excel Discussion (Misc queries) | |||
How to set "fixed decimal" in 2007 | Excel Discussion (Misc queries) | |||
Fixed Decimal stays on Excel 2007 | Excel Discussion (Misc queries) | |||
FIXED 2 DECIMAL PLACES, MUST ENTER ALL ZEROES AFTER DECIMAL POINT. | Excel Discussion (Misc queries) | |||
How do I override fixed decimal place settings in EXcel 2003? | Excel Worksheet Functions |