Donate SIGN UP
Home > Technology > Inserting Date In EXCEL Cell

Inserting Date In EXCEL Cell

Avatar Image
joggerjayne | 13:57 Tue 14th Feb 2012 | Technology
11 Answers
Is there a simple way to insert the date and time into one or two Excel cells (Excel 2010) so that the date and time automatically update?
prev is microsoft frontpage 98 compatable with microsoft office home and student 2007?
  
next What will be the fleet class of the so-called Boris Routemaster Bus?
Gravatar

Answers

1 to 11 of 11rss feed

Best Answer

No best answer has yet been selected by joggerjayne. Once a best answer has been selected, it will be shown here.

For more on marking an answer as the "Best Answer", please visit our FAQ.
Avatar Image flobadob
MarRae or Chuck are your men here jayne.
14:00 Tue 14th Feb 2012
Avatar Image sunny-dave
NOW() in cell
14:01 Tue 14th Feb 2012
Avatar Image HowardKennitby
=today()
14:01 Tue 14th Feb 2012
Avatar Image HowardKennitby
sorry, wrong version XL.
14:02 Tue 14th Feb 2012
Avatar Image sunny-dave
TODAY() gives just the date
14:02 Tue 14th Feb 2012
Avatar Image joggerjayne
Question Author
Golly ... as easy as that?

Thank you, guys.

x
14:03 Tue 14th Feb 2012
Avatar Image Jonathan-Joe
Try "today" function
14:03 Tue 14th Feb 2012
Avatar Image sidkid
=now()
14:03 Tue 14th Feb 2012
Avatar Image sunny-dave
ah - but mine is2007 :+()
14:03 Tue 14th Feb 2012
Avatar Image Mosaic
Type into the cell the formula
=TODAY()
14:06 Tue 14th Feb 2012
Avatar Image sidkid
so is mine but I need the = sign for it to work.......
14:09 Tue 14th Feb 2012

1 to 11 of 11rss feed

Do you know the answer?

Inserting Date In EXCEL Cell

Answer Question >>

Related Questions

Sorry, we can't find any related questions. Try using the search bar at the top of the page to search for some keywords, or choose a topic and submit your own question.