Enter =NOW() in a cell and format as dd-mmm-yy hh:mm

to get text as well format as "Report for "dd-mmm-yy hh:mm

You don't even need to concatenate anything
--
Gary's Student


"vsr_kmb" wrote:


Hello,
I want to show current date and current time in a single cell. I have
tried by using today() and now() functions separately, i dont know how
to use together in a sigle cell. I want like 28-Mar-06, 12.05 PM. Also
I want to add text to it. Like Report for 28-Mar-06.
Experts please help me
Thanks
Ravi


--
vsr_kmb
------------------------------------------------------------------------
vsr_kmb's Profile: http://www.excelforum.com/member.php...o&userid=32834
View this thread: http://www.excelforum.com/showthread...hreadid=527066