E
EWM
I have a very simple job that takes the cell above and adds it to the cell to
the left and so on. About halfway through the column, excel is randomly
dropping a digit out about 10 decimal points. How to fix? See below for
output:
100.0000000000000000
(100.0000000000000000) -
(28.5600000000000000) (28.5600000000000000)
(43.7700000000000000) (72.3300000000000000)
(163.0000000000000000) (235.3300000000000000)
(162.0000000000000000) (397.3300000000000000)
(138.7500000000000000) (536.0800000000000000)
(185.0000000000000000) (721.0800000000000000)
(36.3700000000000000) (757.4500000000000000)
(59.5100000000000000) (816.9600000000000000)
(42.6800000000000000) (859.6400000000000000)
(105.9500000000000000) (965.5900000000000000)
(27.0600000000000000) (992.6500000000000000)
(279.0000000000000000) (1,271.6500000000000000)
(10.2000000000000000) (1,281.8500000000000000)
(14.9900000000000000) (1,296.8400000000000000)
(608.8900000000000000) (1,905.7300000000000000)
(117.7900000000000000) (2,023.5200000000000000)
(19.9900000000000000) (2,043.5100000000000000)
(100.0000000000000000) (2,143.5100000000000000)
4.0000000000000000 (2,139.5100000000000000)
2,190.4300000000000000 50.9199999999996000
4.0000000000000000 54.9199999999996000
4.0000000000000000 58.9199999999996000
4.0000000000000000 62.9199999999996000
4.0000000000000000 66.9199999999996000
4.0000000000000000 70.9199999999996000
4.0000000000000000 74.9199999999996000
4.0000000000000000 78.9199999999996000
4.0000000000000000 82.9199999999996000
4.0000000000000000 86.9199999999996000
4.0000000000000000 90.9199999999996000
4.0000000000000000 94.9199999999996000
4.0000000000000000 98.9199999999996000
4.0000000000000000 102.9200000000000000
4.0000000000000000 106.9200000000000000
the left and so on. About halfway through the column, excel is randomly
dropping a digit out about 10 decimal points. How to fix? See below for
output:
100.0000000000000000
(100.0000000000000000) -
(28.5600000000000000) (28.5600000000000000)
(43.7700000000000000) (72.3300000000000000)
(163.0000000000000000) (235.3300000000000000)
(162.0000000000000000) (397.3300000000000000)
(138.7500000000000000) (536.0800000000000000)
(185.0000000000000000) (721.0800000000000000)
(36.3700000000000000) (757.4500000000000000)
(59.5100000000000000) (816.9600000000000000)
(42.6800000000000000) (859.6400000000000000)
(105.9500000000000000) (965.5900000000000000)
(27.0600000000000000) (992.6500000000000000)
(279.0000000000000000) (1,271.6500000000000000)
(10.2000000000000000) (1,281.8500000000000000)
(14.9900000000000000) (1,296.8400000000000000)
(608.8900000000000000) (1,905.7300000000000000)
(117.7900000000000000) (2,023.5200000000000000)
(19.9900000000000000) (2,043.5100000000000000)
(100.0000000000000000) (2,143.5100000000000000)
4.0000000000000000 (2,139.5100000000000000)
2,190.4300000000000000 50.9199999999996000
4.0000000000000000 54.9199999999996000
4.0000000000000000 58.9199999999996000
4.0000000000000000 62.9199999999996000
4.0000000000000000 66.9199999999996000
4.0000000000000000 70.9199999999996000
4.0000000000000000 74.9199999999996000
4.0000000000000000 78.9199999999996000
4.0000000000000000 82.9199999999996000
4.0000000000000000 86.9199999999996000
4.0000000000000000 90.9199999999996000
4.0000000000000000 94.9199999999996000
4.0000000000000000 98.9199999999996000
4.0000000000000000 102.9200000000000000
4.0000000000000000 106.9200000000000000