Functions showing as text

  • Thread starter Thread starter Sandy
  • Start date Start date
S

Sandy

Just recently when I type a function into certain cells, the function shows
up as text. If I type the function into a cell elsewhere on my sheet and
then cut and paste it into the original cell all is ok. I have tried
changing the formatting of the cell to General, Number, etc and it makes no
difference. I have also tried clearing the contents and formatting; again to
no avail.

Any ideas?

Sandy
 
Maybe...

Saved from a previous post.

Excel likes to help.

Try this on a test worksheet.
Select A1 and hit ctrl-; (to put the date in the cell)
now select B1 and type: =a1

Notice that excel changed the format of B1 to match the format in A1.

Now format D1 as Text.
put ASDF in D1
put =D1 in E1
You see ASDF.

With E1 selected, hit the F2 key and then enter (to pretend that you're changing
the formula).

Excel has "helped" you by changing that cell's format to text.

I don't know of any way of changing this behavior.

I just select the cell, and reformat it to General (or whatever I wanted). I
hit F2 and then enter (to reenter that formula).

Sometimes this feature is nice, sometimes it ain't.
 
If you want to change a lot of formulas after changing the format to general
do a replace and replace = with =
 
Forgot that using data>text to columns and click finish immediately also
creates calculations in all cells and that might be even easier


--

Regards,

Peo Sjoblom

Peo Sjoblom said:
If you want to change a lot of formulas after changing the format to
general
do a replace and replace = with =
Click to expand...
 
Back
Top