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

=NOW()

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"Suleman" wrote in message ...
| 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

=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