Previous Topic Next Topic

TEXT function does not change date format

Solved/Closed
hobbette - 6 Jun 2011 à 07:43
TrowaD Posts 2921 Registration date Sunday 12 September 2010 Status Contributor Last seen 27 December 2022 - 6 Jun 2011 à 08:45
Hello,

I'm using the CONCATENATE function to put together a sentence mixing text and date. The formula I'm using is:

=CONCATENATE("Text part here "; TEXT(B1;"d.m.yyyy"))

I have the date in cell B1 obviously, as "1.6.2011". What I want the formula to produce is "Text part here 1.6.2011". I've tried with different date formats, but I only get "Text part here d.0.yyyy".

I also tried putting the true value of the date in the formula (=CONCATENATE("Text part here "; TEXT(40695;"d.m.yyyy"))) but it doesn't change the format then either.

Any help is greatly appreciated.

Regards,
Pauliina

Related:

1 response

Réponse 1 / 1
TrowaD Posts 2921 Registration date Sunday 12 September 2010 Status Contributor Last seen 27 December 2022 555
6 Jun 2011 à 08:45
Hi Paulina,

Try this:
Cell B1 is formatted as d.m.yyyy and 1.6.2011 is entered as value.
Then the formula: =CONCATENATE("Text part here ";B1) should work.

Does it work?

Could you tell me which language you are using? I've never seen a combination of english function names and the point-comma ( ; ) seperator.

Best regards,
Trowa