Time At Excel

[Suleman]

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

 

[Niek Otten]

=NOW()

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

| 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

 

[Gord Dibben]

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

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


Gord Dibben MS Excel MVP