Editing formula -all I get is formula

[Don O]

Greetings
I'm using excel 2003. I have a list of formulas I created from writing
the first then copying down the line. When I edit any one of them the
return is the formula itself not the result. I've reviewed other
messages in this forum and tried to implement "copy - paste special –
add" from blank cell as well as "change all to general format from
text format" but to no avail. I need either more explicit instruction
or an alternate solution. I never had this problem with previous
versions.
Thanks for your help
Don O

 

[Aladin Akyurek]

Greetings
I'm using excel 2003. I have a list of formulas I created from writing
the first then copying down the line. When I edit any one of them the
return is the formula itself not the result. I've reviewed other
messages in this forum and tried to implement "copy - paste special –
add" from blank cell as well as "change all to general format from
text format" but to no avail. I need either more explicit instruction
or an alternate solution. I never had this problem with previous
versions.
Thanks for your help
Don O

Format the range as General.

Activate Edit|Find.

Find What:

=

Replace With:

=

Click Replace All

 

[Frank Kabel]

Hi
check that the cell is not formated as 'tet'. (format - cells)

 

[Don O]

Thanks Frank that was it.

Hi
check that the cell is not formated as 'tet'. (format - cells)