Date format it text cell.

  • Thread starter Thread starter Nigel Graham
  • Start date Start date
N

Nigel Graham

I am trying to take the value of several cells and display
the text in another:-Cell D2 ="Text "&C2&" part 2 text."

Cell C2 is a date= 38187 [formatted to dd/mm/yy]
What I want in Cell D2 is Text 20/07/04 text. But what I
get is Text 38187 text. I need a function to convert the
numeric date to a usable dd/mm/yy date.

Not crucial but is something I do a lot and is irritating
at times it is not possible.
 
Thanks Arvi,
So simple but irritating at times.
-----Original Message-----
Hi

="..." & TEXT(C2,"dd/mm/yy") & "..."

--
Arvi Laanemets
(Don't use my reply address - it's spam-trap)


Nigel Graham said:
I am trying to take the value of several cells and display
the text in another:-Cell D2 ="Text "&C2&" part 2 text."

Cell C2 is a date= 38187 [formatted to dd/mm/yy]
What I want in Cell D2 is Text 20/07/04 text. But what I
get is Text 38187 text. I need a function to convert the
numeric date to a usable dd/mm/yy date.

Not crucial but is something I do a lot and is irritating
at times it is not possible.
Click to expand...


.
Click to expand...
 
Back
Top