=NOW() formatted to mm/dd/yyyy hh:mm:ss

For static date/time use CTRL + ; <spacebar CTRL + SHIFT + ; <Enter


Gord Dibben MS Excel MVP


On Wed, 30 Apr 2008 12:30:30 -0700, Suleman
wrote:

As If We Need a Date at Excel We Use =Today()
What About We Put The Formula If We Want DAte And Time Together in A cell?

Thanks In Advance