diff --git a/EPPlus/ExcelWorksheet.cs b/EPPlus/ExcelWorksheet.cs
index a88aa33..e4f001e 100644
--- a/EPPlus/ExcelWorksheet.cs
+++ b/EPPlus/ExcelWorksheet.cs
@@ -1536,7 +1536,11 @@
                     }
                     else
                     {
-                        _values.SetValue(row, col, double.NaN);
+                        // Cope with Google Sheets export of cells having a formula.
+                        // Rather than exporting the native value, they export the formatted value.
+                        _values.SetValue(row, col, v);
+
+                        //_values.SetValue(row, col, double.NaN);
                     }
                 }
             }