I believe the key is to not format the cell as text (like use General) and
precede the = with an apostrophe.

--
Jim
"Steven Wazowski"
<Steven.Wazowski.218acn_1136576402.4393@excelfor um-nospam.com wrote in
message news:Steven.Wazowski.218acn_1136576402.4393@excelf orum-nospam.com...
|
| Can anyone tell me how I can display the value:
| =[long value]
| in Excel?
|
| If I format the cell as text, I can put in "=1+1" and it displays as
| such just fine. However, if I want to put more than 1023 characters
| after the initial "=", I get a "Formula too long" error.
|
| I am not specifying a formula. I just want to display a lot of text
| that happens to start with an "=".
|
| Is the only way around this to add a space before the equals sign?
| Tell me there's a better way!
|
|
| --
| Steven Wazowski
| ------------------------------------------------------------------------
| Steven Wazowski's Profile:
http://www.excelforum.com/member.php...o&userid=30199
| View this thread: http://www.excelforum.com/showthread...hreadid=498823
|