![]() |
#1
|
|||
|
|||
![]()
I use Excel 2013. I have a table with 2000 rows. One column is calculated by subtracting two 2-decimal columns from another 2-decimal column. Each of those columns are typed in and there is no odd data.
There are only 16 examples of this, but it is weird - this is what the column holds for those rows: Amount Due $(0.0000000000104773793807578000) $(0.0000000000072759576141834300) $(0.0000000000036379788070917100) $(0.0013592233008239400000000000) $(0.0021359223301260500000000000) $(0.0000000000006821210263296960) $(0.0029999999956089600000000000) $(0.0000000000291038304567337000) $(0.0000000000072759576141834300) $(0.0000000000072759576141834300) $(0.0000000000072759576141834300) $(0.0000000000072759576141834300) $(0.0000000000011652900866465600) $(0.0000000000372892827726901000) $(0.0000000000000248689957516035) $(0.0000000000003979039320256560) $(0.01) this is a subtotal row Any idea why this happened? |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
![]() |
wheddingsjr | Excel | 3 | 07-26-2019 07:41 AM |
How to create a decimal point after each number in a numbered list in excel | wondermuse | Excel | 1 | 03-06-2017 03:42 AM |
Pulling 2 digits before a decimal point from adjoining cell then zeros after decimal | jadess916 | Excel | 1 | 06-26-2014 03:48 AM |
![]() |
Glynda | Mail Merge | 1 | 04-08-2011 12:17 AM |
![]() |
gchan2000 | Excel | 1 | 08-17-2010 01:36 PM |