Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]() 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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How change the date format in the excel footer to dd mmm yy? | Excel Discussion (Misc queries) | |||
Change FORMAT | Excel Discussion (Misc queries) | |||
Compare dates (one cell not in date format) | Excel Discussion (Misc queries) | |||
Automatically Insert DATE, so that DATE will NOT change | Excel Worksheet Functions | |||
change date function format in footer | Excel Worksheet Functions |