Formatting the value of a cell reference in a formula
 

I am trying to use a formula to concatenate 2 cells, one is text and the
other is a date. When I enter the formula the date appears as a number. Is
there a way to format just the cell that contains the date to show as a date?
--
Thank You,
Steve

Formatting the value of a cell reference in a formula
 

Hi

Something like this:
=A1 & " " & TEXT(B1,"dddd d. mmmm yyyy")


--
Arvi Laanemets
( My real mail address: arvi.laanemets<attarkon.ee )



"Steve D" wrote in message
...
I am trying to use a formula to concatenate 2 cells, one is text and the
other is a date. When I enter the formula the date appears as a number. Is
there a way to format just the cell that contains the date to show as a
date?
--
Thank You,
Steve