Security & Virus | Hardware | Windows XP | Windows Vista | PC Gaming

Date changing

Comment:

I need help!!! I have a word document that I converted to an Excel file. In one column is dates, ie: 5/17/07 and some are just 5/07. Excel changes the 5/07 to 5/01/07. I cannot have that. It has to stay exactly as typed. What can i do

Name: AlwaysWillingToLearn
Date: October 14, 2009 at 07:30:39 Pacific

Reply:

If you right click the cell, then go to format cells, under Custom change the TYPE field to dd/yy and press ok. This will show it up at 05/07. Change it to d/yy to show it as 5/07. for months obviously use mm/yy

0

PHONE DIALER WON"T ...

usb driver problem

Summary: I am not sure if it is the CMOS battery failing or if its a virus, but I am having a problem with the system date changing a lot. It will change from 2007 to 3007 and sometimes to 11007. If I boot int...

Summary: my date keeps on changing in my cmos or bios, i already changed the baterries, the clock doesn't change only the date ...

Summary: I use this programme to change the date of creation/change in files: http://www.cfisoft.com/products/shelltoys/index.asp this is really useful, 'cause I sort my photos by date of change, but sometime...