Results 1 to 3 of 3
  1. #1
    4 Star Lounger
    Join Date
    Dec 2000
    Location
    Faifax, Virginia, USA
    Posts
    542
    Thanks
    0
    Thanked 0 Times in 0 Posts

    formulas dont get evaluated (2003)

    an xls is exported by a 3rd party app. Open said xls in v 2003. Panes frozen at a2. Column labels. Row 1 background color = yellow. AutoFilter On.

    Turn off autofilter.

    When i insert a new column b, and type '=Trim(a2)', the formula is not evaluated. It just lies there. Delete the new B.

    When I insert a column to the left of A and enter '=Trim(b2)', the formula is evaluated.

    What is it about the imported range that would prevent formulae from being evaluated?

  2. #2
    Uranium Lounger
    Join Date
    Jan 2001
    Location
    South Carolina, USA
    Posts
    7,295
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: formulas dont get evaluated (2003)

    It sounds like the new column B is formatted as text. When you insert the new column B, select the column and change the format to "General" before you enter the formula.
    Legare Coleman

  3. #3
    4 Star Lounger
    Join Date
    Dec 2000
    Location
    Faifax, Virginia, USA
    Posts
    542
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: formulas dont get evaluated (2003)

    Egg ZACKLY right!

    Thanks Legare

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •