Displaying formula rather than results...
 

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

Displaying formula rather than results...
 

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

Displaying formula rather than results...
 

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

Displaying formula rather than results...
 

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