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
|