Concatenate problem

  • Thread starter Thread starter Chuck W
  • Start date Start date
C

Chuck W

Hi,

I am trying to concatenate two cells. One has a month and
with slashes in between such as 01/16/ or 02/09/. The
second cell has a year such as 03 or 04. I choose the
Concatenate function and select cell b2 for text1 and c2
for text2. The value that I want appears in the
concatenate screen as 01/16/03. However, when I select
OK I get a value that says =CONCATENATE (B2,C2). So I am
getting the function or formula rather than the actual
value with is a date.

Can anyone help me with this?

Thanks,

Chuck
 
I am getting the function or formula rather than the actual
value with is a date.
Click to expand...

Chuck,

I am guessing, but do you have Tools | Options | View | Formulas checked?
If so, uncheck it.

Regards,
Kevin
 
Funny thing...If you type the formula in the cell directly rather then using the formula palette, it works. If you activate the cell and open the formula palette, it will display the formula, not the value. I've checked Tools | Options | View | Fomulas is UNchecked. Strange

Glenn
 
Most likely the cell is (or was at one time) formatted as text. Format the
cell as general, and re-enter the formula (or, if the formula is already
there, hit F2, then Enter).
 
My guess is that the cell is formatted as Text.

And after you format the cell as general, you're formula will be ok (hit F2
followed by enter to get excel to reevaluate it for you).

But this formula will work, too:

=B2&C2

And I think I'd use this:
=DATEVALUE(b2&c2)
and format the cell as a date.

Once the values are real dates, you can lots more with them.
 
You have probably got the formula cell formatted as Text, and so will
need to change that.
 
Back
Top