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..
Please Login or Register to view this content.
Please Login or Register to view this content.
Last edited by johncena; 03-12-2010 at 09:16 AM.
Hi,
Try this?
="DYEING QUEUE AS AT "&TODAY()&" - MULTIPRECISE SAMPLE MACHINE"
Rule 1: Never merge cells
Rule 2: See rule 1
"Tomorrow I'm going to be famous. All I need is a tennis racket and a hat".
thanks sweep,which format i have to use ??
Just enter that into a cell, and it should give you the result you want.
..actually it won't try this
="DYEING QUEUE AS AT "&TEXT(TODAY(),"dd/mm/yyyy")&" - MULTIPRECISE SAMPLE MACHINE"
Re: Date with Text
thanks u very much.this formula work for me,,,,,,,
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks