automatically having the date in excel 2003

-
    To put today's date into excel  2003
pick a cell and type in the formula = now( )
remember to put a space between the parenthesis
save the  file.
if you open the file on different days  remember that days date will be shown.
example: if youopen the file on weds 02/03/2010 should show
reopen on the following day thedate should be 02/04/2010
Have a great day

Comments

Post a Comment

Popular posts from this blog

outlook repair

-
If you need to fix something that has gone wrong with outlook program itself click on help then detect and repair click ok to the box that appears and outlook will attempt to find and repair any problems that the program has
Read more

Microsoft list of dates for end of support

-
Client operating systems Latest update or service pack End of mainstream support End of extended support Windows XP Service Pack 3 April 14, 2009 April 8, 2014 Windows Vista Service Pack 2 April 10, 2012 April 11, 2017 Windows 7 * Service Pack 1 January 13, 2015 January 14, 2020 Windows 8 Windows 8.1 January 9, 2018 January 10, 2023 　 　 Desktop operating systems Date of availability Support retired Windows XP SP1 August 30, 2002 October 10, 2006 Windows XP SP2 September 17, 2004 July 13, 2010 Windows XP SP3 April 21, 2008 April 8, 2014 Windows Vista SP1 February 4, 2008 July 12, 2011 Windows Vista SP2 May 26, 2009 Available now Windows 7 SP1 February 22, 2011 Available now
Read more

Lync Online contacts are lost or missing, or the contact list isn't updated

-
Scenario 3: Lync Online contacts are lost or missing, or the contact list isn't updated In rare cases, the contact list may be corrupted because of an invalid character in an "out of office" message or because a lingering deprovisioned contact exists. To resolve this problem, force a contact list update to make sure that your information is synchronized. To this, follow these steps: Locate one of the following folders, depending on your operating system: For Lync 2013: Windows 7 and Windows 8: %localappdata%\Microsoft\Office\15.0\Lync\sip_ For Lync 2010: Windows 8, Windows 7, or Windows Vista: %localappdata%\Microsoft\Communicator\sip_ Windows XP: %userprofile%\Local Settings\Application Data \Microsoft\Communicator\sip_ Delete the following files: Galcontacts.db galcontacts.db.idx CoreContact.cache ABS_ .cache Mfugroup.cache PersonalLISDB.cache PresencePhoto.cache Restart Lync, and then wait for 30 minutes for resynchronization to finish.
Read more