Date with Text
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)....
possible to add above word with this..DYEING QUEUE AS AT 12.03.10 - MULTIPRECISE SAMPLE MACHINE
=today()
Last edited by johncena; 03-12-2010 at 08:16 AM.
Hi,
Try this?
="DYEING QUEUE AS AT "&TODAY()&" - MULTIPRECISE SAMPLE MACHINE"
Please disregard anything in the above post. It may well have been edited without my consent, as has been the case with several posts and threads recently.
thanks sweep,which format i have to use ??
Just enter that into a cell, and it should give you the result you want.
Please disregard anything in the above post. It may well have been edited without my consent, as has been the case with several posts and threads recently.
..actually it won't try this
="DYEING QUEUE AS AT "&TEXT(TODAY(),"dd/mm/yyyy")&" - MULTIPRECISE SAMPLE MACHINE"
Please disregard anything in the above post. It may well have been edited without my consent, as has been the case with several posts and threads recently.
Re: Date with Text
thanks u very much.this formula work for me,,,,,,,
="DYEING QUEUE AS AT "&TEXT(TODAY(),"dd/mm/yyyy")&" - MULTIPRECISE SAMPLE MACHINE"
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks