Previous Topic Next Topic

TEXT function does not change date format

Solved/Closed
hobbette - Jun 6, 2011 at 07:43 AM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen January 16, 2023 - Jun 6, 2011 at 08:45 AM
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 reply

Answer 1 / 1
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen January 16, 2023 545
Jun 6, 2011 at 08:45 AM
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
0