Hi Ravi...........
Here's a formula solution..........

="Report for "&TEXT(NOW(),"MMM dd, yyyy hh:mm AM/PM")

hth
Vaya con Dios,
Chuck, CABGx3




"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