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.

lireland wrote:

Dave,

Thanks for your reply. I just got finished answering "Gary's student" more
extensively (above), and I think you're both right. I don't know how I came
to have those cells formatted as text, unless there's some shortcut to do
that that I hit accidentally. I'll have to wait until it comes up again
sporadically to test if that's what's always happening, but I suspect you're
both right. Thanks again!

"Dave Peterson" wrote:

Try formatting the cell as General (or anything but Text), then with that cell
selected, hit F2, then Enter.



lireland wrote:

I used to routinely use the concatenate formula in excel, with either syntax:
=CONCATENATE(A1,B1,C1) -OR-
=A1&B1&C1

Lately, sporadically, it just doesn't work, leaves my cell sitting with a
literal that looks like the formula rather than showing the concatenated
value. I don't have the Tool/Options/View Formula option checked, nor have I
used the Ctl-` command to turn this on or off. The only way I seem to be
able to get around this is by copying a concatenated formula option out of
help and pasting it, and then editing it to suit my situation, the Insert
Function does not work, either. I HAVE checked my formulas VERY CAREFULLY
for misplaced spaces or commas, etc., and I can't find any typos. Any
suggestions?

--

Dave Peterson


--

Dave Peterson