software

Running Excel 2003 (11.6560.6568) SP2.

Worksheet 1 is my form, worksheet 2 is my data log. I log my transactions,
one per row, of data log. I have a macro, which copies the appropriate row
of data from worksheet 2 to line 50 of the form tab. The form is set up to
read line 50 and quot;fill in fieldsquot; accordingly. For example, H42:V42, which
is a merged cell, I have the following: =IF(X50lt;gt;quot; quot;,X50,quot; quot;).

My problem is that H42:V42 is displaying the formula, rather than the
result, which is the data from X50.

Please Help!!!

TIA,
Sandi

Check Tool -gt; Options -gt; View and see if you have formulas checked.

quot;RUSH2CROCHETquot; wrote:

gt; Running Excel 2003 (11.6560.6568) SP2.
gt;
gt; Worksheet 1 is my form, worksheet 2 is my data log. I log my transactions,
gt; one per row, of data log. I have a macro, which copies the appropriate row
gt; of data from worksheet 2 to line 50 of the form tab. The form is set up to
gt; read line 50 and quot;fill in fieldsquot; accordingly. For example, H42:V42, which
gt; is a merged cell, I have the following: =IF(X50lt;gt;quot; quot;,X50,quot; quot;).
gt;
gt; My problem is that H42:V42 is displaying the formula, rather than the
gt; result, which is the data from X50.
gt;
gt; Please Help!!!
gt;
gt; TIA,
gt; Sandi

Barb:

Thanks for your prompt reply, however, I did not have quot;formulasquot; checked on
my option bar. Any other suggestions?

TIA,
Sandi

quot;Barb Reinhardtquot; wrote:

gt; Check Tool -gt; Options -gt; View and see if you have formulas checked.
gt;
gt; quot;RUSH2CROCHETquot; wrote:
gt;
gt; gt; Running Excel 2003 (11.6560.6568) SP2.
gt; gt;
gt; gt; Worksheet 1 is my form, worksheet 2 is my data log. I log my transactions,
gt; gt; one per row, of data log. I have a macro, which copies the appropriate row
gt; gt; of data from worksheet 2 to line 50 of the form tab. The form is set up to
gt; gt; read line 50 and quot;fill in fieldsquot; accordingly. For example, H42:V42, which
gt; gt; is a merged cell, I have the following: =IF(X50lt;gt;quot; quot;,X50,quot; quot;).
gt; gt;
gt; gt; My problem is that H42:V42 is displaying the formula, rather than the
gt; gt; result, which is the data from X50.
gt; gt;
gt; gt; Please Help!!!
gt; gt;
gt; gt; TIA,
gt; gt; Sandi

Are those fields formatted as text?

quot;RUSH2CROCHETquot; wrote:

gt; Barb:
gt;
gt; Thanks for your prompt reply, however, I did not have quot;formulasquot; checked on
gt; my option bar. Any other suggestions?
gt;
gt; TIA,
gt; Sandi
gt;
gt; quot;Barb Reinhardtquot; wrote:
gt;
gt; gt; Check Tool -gt; Options -gt; View and see if you have formulas checked.
gt; gt;
gt; gt; quot;RUSH2CROCHETquot; wrote:
gt; gt;
gt; gt; gt; Running Excel 2003 (11.6560.6568) SP2.
gt; gt; gt;
gt; gt; gt; Worksheet 1 is my form, worksheet 2 is my data log. I log my transactions,
gt; gt; gt; one per row, of data log. I have a macro, which copies the appropriate row
gt; gt; gt; of data from worksheet 2 to line 50 of the form tab. The form is set up to
gt; gt; gt; read line 50 and quot;fill in fieldsquot; accordingly. For example, H42:V42, which
gt; gt; gt; is a merged cell, I have the following: =IF(X50lt;gt;quot; quot;,X50,quot; quot;).
gt; gt; gt;
gt; gt; gt; My problem is that H42:V42 is displaying the formula, rather than the
gt; gt; gt; result, which is the data from X50.
gt; gt; gt;
gt; gt; gt; Please Help!!!
gt; gt; gt;
gt; gt; gt; TIA,
gt; gt; gt; Sandi