Results 1 to 6 of 6
  1. #1
    Join Date
    May 2006
    Posts
    28

    Unanswered: Function not returning a value

    I have a cell (E2 for example) with 061120 as the value. In another cell, I create the function: =LEFT(E2,2) in order to extract the "06" from the E2 cell but when I click enter, all that it says is =LEFT(E2,2) and no value... Does anyone know why or what I'm doing wrong?

  2. #2
    Join Date
    Feb 2006
    Posts
    113
    Hi,

    Try CTRL-` (The shortcut for toggling tools, options, view, formulas)

    ?
    Fazza

  3. #3
    Join Date
    May 2006
    Posts
    28
    Nope, that didn't work...

  4. #4
    Join Date
    Feb 2006
    Posts
    113
    Whatabout forcing calculation if you have "Calculate" in the status bar? Maybe F9.

    Or, is the cell formatted as text? Try CTRL-SHIFT_~ to reset format

  5. #5
    Join Date
    May 2006
    Posts
    28
    Thanks! I'm not sure what worked (I did multiple things including F9 and CTRL+SHIFT) so I'm not sure which one did it but it's working now. Thanks again!

  6. #6
    Join Date
    Feb 2006
    Posts
    113
    Great. (BTW, one I forgot to mention earlier CTRL-ALT-F9 is an undocumented recalc everything key sequence.)

Posting Permissions

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