really annoying (but probably easy) problem!!

Posted by danielle on April 09, 2001 6:51 AM

hopefully someone can help me with this!!

I am trying to put a simple formula into a field but Excel keeps taking it as a value instead of a formula!!

driving me crazy so if anyone could help that would be good.

Thanks,
Danielle

Posted by DCP on April 09, 2001 7:02 AM

Are you remembering to enter an = before your formula

Posted by Aladin Akyurek on April 09, 2001 7:09 AM

Or...

the formatting of the cell is text.

Posted by Danielle on April 09, 2001 7:22 AM

I've tried both of these thing but to no avail!!

danielle

Posted by Danielle on April 09, 2001 7:23 AM

Re: Or...

I've tried both of these things but to no avail!!

danielle

Posted by JAF on April 09, 2001 7:23 AM

Another Possibility

Is the spreadsheet set to display formulas?

Check under Tools/Options - on the View tab if the Formulas box is ticked, un-tick it.

Posted by Danielle on April 09, 2001 9:36 AM

Still didn't fix it........!

Posted by Aladin Akyurek on April 09, 2001 10:33 AM

Danielle

What is the formula and where are you trying to put it?

Aladin

Posted by Tommy Christensen on April 09, 2001 12:46 PM

Instead of code, have you tried the filter capabilities of Excel? This will allow you to set criteria for customer and your column O and display only those rows that fullfill the criteria. Just check help for Advanced Filter.

Posted by Tommy Christensen on April 09, 2001 12:51 PM

Re: Or...

Hi
The cell is probably formattet as text. Change the format to General. Then press F2 to edit the cell and Enter.
Tommy