Results 1 to 7 of 7
  1. #1
    5 Star Lounger jujuraf's Avatar
    Join Date
    Jun 2001
    Location
    San Jose, California, USA
    Posts
    1,061
    Thanks
    0
    Thanked 0 Times in 0 Posts

    formula '=' seen as text (Excel 2003, SP2)

    This is the weirdest thing... When I'm in a spreadsheet and enter a formula in the usual way that points to another cell actually get see it as text (=E57, for example), not the result of the formula. I've tried this on several cells, close, re-open Excel, but I can't get it to quit doing that. There doesn't seem to be a pattern of format for the source cell (text, number, etc.). This is a workbook I've been messing with for a few months so maybe something is getting corrupted since I don't see it in new workbooks. There is no VBA in this workbook. I know another co-worker who asked me about it but at that time I'd never seen it myself. Anyone else see this?

    I have to reboot to get it to work as usual.

    Deb

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: formula '=' seen as text (Excel 2003, SP2)

    Have you checked whether the Formulas box in the View tab of Tools | Options is ticked? If so, clear it.

  3. #3
    5 Star Lounger jujuraf's Avatar
    Join Date
    Jun 2001
    Location
    San Jose, California, USA
    Posts
    1,061
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: formula '=' seen as text (Excel 2003, SP2)

    No, that option field isn't checked. Actually I've never used that Formulas checkbox in Options but now I see that it does the same thing as Ctrl + ~ which I do use. <img src=/S/cool.gif border=0 alt=cool width=15 height=15>

    Since I have seen this on another person's PC (and at that time I didn't believe them - until it happened to me) so Excel somehow gets stuck in some mode. It eventually unsticks itself if I point that cell to something else but it does keep coming back. Fortunately I'm pretty much done with this spreadsheet so won't need to create new formulas.

    Oh well, it's an oddity.

    Deb

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

    Re: formula '=' seen as text (Excel 2003, SP2)

    If that option is not set, then the only other thing that could cause this is that the cell was formatted as Text when the formula was entered. Change the format of the cell(s) to General. Just changing the format will not change the formula from a text string into a formula. After changing the format, double click the cell and then press enter. That should change the text into a formula.
    Legare Coleman

  5. #5
    5 Star Lounger jujuraf's Avatar
    Join Date
    Jun 2001
    Location
    San Jose, California, USA
    Posts
    1,061
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: formula '=' seen as text (Excel 2003, SP2)

    Yes, I had noticed earlier that the format of the "text' formula cell was formatted as text before but I couldn't quite resolve it. Your suggestion worked though. <img src=/S/clapping.gif border=0 alt=clapping width=19 height=23>

    This still seems very weird to me, how the existing cell formatting derailed the formula. I'll have to experiment with other cell formats to see how that changes things too.

    <img src=/S/bravo.gif border=0 alt=bravo width=16 height=30> Deb

  6. #6
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: formula '=' seen as text (Excel 2003, SP2)

    If a cell is formatted as Text, anything entered into it will be seen as plain text, and displayed exactly as it was entered. So if you enter =N34 into a cell formatted as text, that cell will contain the text =N34, not the formula =N34.

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

    Re: formula '=' seen as text (Excel 2003, SP2)

    Any numeric format (ie all formats except Text) should display the result of the formula in the specified format. If the format is Text, then whatever is entered is entered as a text string and not as a number or a formula.
    Legare Coleman

Posting Permissions

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