Fill cells with null if amount is zero

1 files changed, 8 insertions, 1 deletions

diff --git a/RhSolutions.AddIn/Services/ExcelWriterBase.cs b/RhSolutions.AddIn/Services/ExcelWriterBase.cs
index 2a98b21..3ec5348 100644
--- a/RhSolutions.AddIn/Services/ExcelWriterBase.cs
+++ b/RhSolutions.AddIn/Services/ExcelWriterBase.cs
@@ -134,7 +134,14 @@ namespace RhSolutions.Services
                 }
                 else
                 {
-                    cell.Value2 = amount;
+                    if (amount == 0)
+                    {
+                        cell.Value2 = null;
+                    }
+                    else
+                    {
+                        cell.Value2 = amount;
+                    }
                 }
             }
         }