View Single Post
  #1   Report Post  
woodlot4
 
Posts: n/a
Default Change general format to US date format


I have a list of contacts with data. One of the columns is for "date".
However, ONe of the lists I have has the date formatted as "general" and
when I try to format it as date it puts the wrong number in it.
Example: column G reads 10298 which is the date 01/02/1998. No
matter what I try I cannot get it to read as a date. Please help. I
have searched the forum over and over and cannot find the answer to
this issue. My anxiety is through the roof!
email help to woodlot4 at yahoo.com


--
woodlot4
------------------------------------------------------------------------
woodlot4's Profile: http://www.excelforum.com/member.php...o&userid=26613
View this thread: http://www.excelforum.com/showthread...hreadid=474866