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.
Ask a Question
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.
