Content feed Comments Feed

InfoMatterz

Information that Matters

How to Enter Fix Date or Time in Excel ?

Posted by A1 On June - 13 - 2009

To Enter Fix DateTime that is the date/time want change even when you open  excel next time follow the simple steps:

1. Open Excel.

How to Enter Fix Date or Time in Excel ? Photu2.   Press [Ctrl] + [;] for the date.

How to Enter Fix Date or Time in Excel ? Photu

3. Press  [Ctrl] + [:]  for the time.

How to Enter Fix Date or Time in Excel ? Photu

Share and Enjoy:
  • Digg
  • Sphinn
  • del.icio.us
  • Facebook
  • Mixx
  • Google Bookmarks
  • Fark
  • LinkedIn
  • Tipd
  • Gwar
  • Live
  • NewsVine
  • Propeller
  • Reddit
  • Slashdot
  • StumbleUpon
  • Yigg

Related posts:

  1. How To calculate difference between dates in Excel ?
  2. How to Hide Alternate Columns in Excel ?
  3. How to Find the currently Active Cell ?

Extra

Leave a Reply

About Us

We are group of people who have started this website called as InfoMatterz, it will be containing the information related to various subjects, as the authors on the site are having a wide area of experience in their field. It contains information about Technology, Health and Finance.

Recent Posts

Recent Comments