I want to validate cell with the following text formats
Case-1: -1.50-0.25x180 or +1.50+0.00x180
Case-2: -1.50-0.25x180 ADD+1.00 BF or +1.50+0.00x180 ADD+1.00 BF
Using (+#0.00,-#0.00) works fine for +1.50 or -1.50 or +0.00 or -0.00
I am using the following format for the entitre text, but I get an error
_(+#0.00,-#0.00);_(+#0.00,-#0.00);_("x"_);_(000)
+1.50 -0.25 x 180
Any Ideas?
Case-1: -1.50-0.25x180 or +1.50+0.00x180
Case-2: -1.50-0.25x180 ADD+1.00 BF or +1.50+0.00x180 ADD+1.00 BF
Using (+#0.00,-#0.00) works fine for +1.50 or -1.50 or +0.00 or -0.00
I am using the following format for the entitre text, but I get an error
_(+#0.00,-#0.00);_(+#0.00,-#0.00);_("x"_);_(000)
+1.50 -0.25 x 180
Any Ideas?