enter # 12.00 for examples and excel use 12.00000028434000

B

Bill Carrico

This happens (frustratingly - because I cannot proof footing and crossfooting. It seems that Excel just adds in the extra #'3 after the .00. I will delete the number and rekey it and the extra decimals come again (albeit different #'s). I will delete the row and rekey the 12.00 again and yet I get something like 12.00000658745000 (different decimal number but same problem).
 
P

Pinks

Hi Bill
Looks like you've taken the wrong option in format cells. Select all ( Ctrl - A ) if you wish to keep the same for the whole document or select those particular cells only, right click, format cells, number category, Set the Decimal places to 2
Hope that solves your problem
Regards
Pinky Variava
 
B

Bill Carrico

I have decimal places set to two. However, Excel still stores 16 places after the decimal. My problem is that for example I enter 12.42 (with decimal places set to two) and excel stores (for example) 12.42000574654000

Sometimes in adding columns with 2 decimals for example 12.00 and 11.50 excel will store 23.500000549329000

This happens very randomly.
 
D

Dave Peterson

I've never seen excel be off by this much. And I couldn't duplicate when I
typed in 12.42000000000 or 11.5000000.

Does this happen in all your workbooks?

Does it happen if you start excel in safe mode:

Close excel
windows start button|Run
excel /safe

File|Open your workbook and see what happens.

(I used xl2002 for my testing. What version are you using? Maybe someone with
that version can chime in.)
 
D

Dave Peterson

I've never seen excel off by that much for any data entry.

xl2002 worked ok for me when I typed in 12.0000000 and 11.50000000

Does it happen on all your workbooks--even a worksheet in a new workbook?

Maybe trying it with excel in safe mode would shed some light:

Close excel
windows start button|Run
excel /safe

File|Open your workbook and see what happens.

What version of excel are you running? Maybe someone can chime in.
 
D

Dave Peterson

Yes, my newsreader crashed between the first and second posts. I wasn't sure
the first made it.
 
B

bill carrico

Thanks Dave Peterso

You can't duplicate because this happens so randomly - This has been happening to me for several years on different versions of excel, different networks and different CPU's. It is very confusing and frustrating. A few years back I called MS Excel and they said to delete the cell and reenter. This solution has never worked. I asked several other people about this and they never saw it happen.

If would not know except I am a CPA and work with spreadsheets where I foot and crossfoot the columns e.

Columns A - E and rows 1 thru 80 with various numbers in eac
Column F is the cross foot (Sum(a:e) total
Row 81 is the downfoot totals (sum(1:80

I then proof the final totals down and accross in Column F row 81 as follows

if(sum(a81:e81)=sum(f1:f80),sum(f1:f80),"error") - The result is normally okay - However occasionally is get the result of "error" which means the sum down does not equal the sum accross. I manually proof the down and accross and they are okay. I then expand the 2 decimal point format of the cells to 16 decimal points and low and behold I find a number something like 93.000002346323000 in one of the cells

Amazing...
 
D

Dave Peterson

And these cells are not the results of calculations? Or even dragging down a
column?

Excel can do strange things with data entry, but I've never seen it do anything
with something simple like 93.

Numbers Ending in .848 Appear Incorrectly
http://support.microsoft.com/default.aspx?scid=kb;en-us;Q161234

I didn't see your version of excel. If you post it, maybe someone can offer a
better suggestion.


And starting in Safe mode didn't help??
 
Top