Date with Text

[johncena]

dear friends i want to update my document date automatically.but the problem is my document date with some words also there,it's like this(below all data in one cell)....

DYEING QUEUE AS AT 12.03.10 -  MULTIPRECISE SAMPLE MACHINE

possible to add above word with this..

=today()

[sweep]

Hi,

Try this?

="DYEING QUEUE AS AT "&TODAY()&" - MULTIPRECISE SAMPLE MACHINE"

[johncena]

thanks sweep,which format i have to use ??

[sweep]

Just enter that into a cell, and it should give you the result you want.

[sweep]

..actually it won't try this

="DYEING QUEUE AS AT "&TEXT(TODAY(),"dd/mm/yyyy")&" - MULTIPRECISE SAMPLE MACHINE"

[johncena]

thanks u very much.this formula work for me,,,,,,,

="DYEING QUEUE AS AT "&TEXT(TODAY(),"dd/mm/yyyy")&" - MULTIPRECISE SAMPLE MACHINE"