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 "fill in fields" accordingly. For example, H42:V42, which
is a merged cell, I have the following: =IF(X50<" ",X50," ").

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 - Options - View and see if you have formulas checked.

"RUSH2CROCHET" wrote:

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 "fill in fields" accordingly. For example, H42:V42, which
is a merged cell, I have the following: =IF(X50<" ",X50," ").

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

Please Help!!!

TIA,
Sandi

Barb:

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

TIA,
Sandi

"Barb Reinhardt" wrote:

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

"RUSH2CROCHET" wrote:

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 "fill in fields" accordingly. For example, H42:V42, which
is a merged cell, I have the following: =IF(X50<" ",X50," ").

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

Please Help!!!

TIA,
Sandi

Are those fields formatted as text?

"RUSH2CROCHET" wrote:

Barb:

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

TIA,
Sandi

"Barb Reinhardt" wrote:

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

"RUSH2CROCHET" wrote:

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 "fill in fields" accordingly. For example, H42:V42, which
is a merged cell, I have the following: =IF(X50<" ",X50," ").

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

Please Help!!!

TIA,
Sandi