diff --git a/ClosedXML/Excel/CalcEngine/Functions/Text.cs b/ClosedXML/Excel/CalcEngine/Functions/Text.cs
index 8e35edf..b91728c 100644
--- a/ClosedXML/Excel/CalcEngine/Functions/Text.cs
+++ b/ClosedXML/Excel/CalcEngine/Functions/Text.cs
@@ -256,6 +256,11 @@
 
         private static object _Text(List<Expression> p)
         {
+            var value = p[0].Evaluate();
+
+            // Input values of type string don't get any formatting applied.
+            if (value is string) return value;
+
             var number = (double)p[0];
             var format = (string)p[1];
             if (string.IsNullOrEmpty(format.Trim())) return "";
@@ -343,4 +348,4 @@
                 return retVal;
         }
     }
-}
\ No newline at end of file
+}
diff --git a/ClosedXML_Tests/Excel/CalcEngine/TextTests.cs b/ClosedXML_Tests/Excel/CalcEngine/TextTests.cs
index 013950b..b5a940e 100644
--- a/ClosedXML_Tests/Excel/CalcEngine/TextTests.cs
+++ b/ClosedXML_Tests/Excel/CalcEngine/TextTests.cs
@@ -480,6 +480,13 @@
         }
 
         [Test]
+        public void Text_String_Input()
+        {
+            Object actual = XLWorkbook.EvaluateExpr(@"TEXT(""211x"", ""#00"")");
+            Assert.AreEqual("211x", actual);
+        }
+
+        [Test]
         public void Trim_EmptyInput_Striong()
         {
             Object actual = XLWorkbook.EvaluateExpr(@"Trim("""")");
@@ -523,4 +530,4 @@
             Assert.AreEqual(654.32, actual);
         }
     }
-}
\ No newline at end of file
+}