Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
date problem in excel
dear all , PLS HELP ME SOON . IM FACING A PROBLEM IN DATE FORMAT . I GOT A DATA(500) FORM SYSTEM , THERE THE DATE FORMAT WAS 060606 THAT MEAN (06-JUN-06) . NOW I WANT TO CHANGE THAT FORMAT TO THIS FORMAT(DD-MMM-YY) BY USING 1 FUNCTION OF FORMULA. ARINDAM -- arindamkol_1978 ------------------------------------------------------------------------ arindamkol_1978's Profile: http://www.excelforum.com/member.php...o&userid=35861 View this thread: http://www.excelforum.com/showthread...hreadid=560751 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
date problem in excel
Hi,
try to use it =date(20&right(a1,2),mid(a1,3,2),left(a1,2)) format as date dd-mmm-yy hth regards from Brazil Marcelo "arindamkol_1978" escreveu: dear all , PLS HELP ME SOON . IM FACING A PROBLEM IN DATE FORMAT . I GOT A DATA(500) FORM SYSTEM , THERE THE DATE FORMAT WAS 060606 THAT MEAN (06-JUN-06) . NOW I WANT TO CHANGE THAT FORMAT TO THIS FORMAT(DD-MMM-YY) BY USING 1 FUNCTION OF FORMULA. ARINDAM -- arindamkol_1978 ------------------------------------------------------------------------ arindamkol_1978's Profile: http://www.excelforum.com/member.php...o&userid=35861 View this thread: http://www.excelforum.com/showthread...hreadid=560751 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
date problem in excel
for years before 2000, exclude 20& on the formula
regards "Marcelo" escreveu: Hi, try to use it =date(20&right(a1,2),mid(a1,3,2),left(a1,2)) format as date dd-mmm-yy hth regards from Brazil Marcelo "arindamkol_1978" escreveu: dear all , PLS HELP ME SOON . IM FACING A PROBLEM IN DATE FORMAT . I GOT A DATA(500) FORM SYSTEM , THERE THE DATE FORMAT WAS 060606 THAT MEAN (06-JUN-06) . NOW I WANT TO CHANGE THAT FORMAT TO THIS FORMAT(DD-MMM-YY) BY USING 1 FUNCTION OF FORMULA. ARINDAM -- arindamkol_1978 ------------------------------------------------------------------------ arindamkol_1978's Profile: http://www.excelforum.com/member.php...o&userid=35861 View this thread: http://www.excelforum.com/showthread...hreadid=560751 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
date problem in excel
dear all, thanks for trying this. but it was not warking . it have some error if i used this formula [ DATE(20&RIGHT(B2,2),MID(B2,3,2),LEFT(B2,2)) ] and put 060606 then I got the date as 05/12/2065 . Pls help me .............. , i could not solved it still now. arindam -- arindamkol_1978 ------------------------------------------------------------------------ arindamkol_1978's Profile: http://www.excelforum.com/member.php...o&userid=35861 View this thread: http://www.excelforum.com/showthread...hreadid=560751 |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
date problem in excel
hi, Im very sorry. 2morrow i send u a mail and told the function was not working , but at night i solved the problem . the function was correct . I was wrong.Thanks a lot . Bfore 2day i update the date field 1by1.Every day i have 2 update atlist 500 data. Now i doing that only one function. I want to friendship with u , if u want then pls mail me in this ) Thanks . -- arindamkol_1978 ------------------------------------------------------------------------ arindamkol_1978's Profile: http://www.excelforum.com/member.php...o&userid=35861 View this thread: http://www.excelforum.com/showthread...hreadid=560751 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Problem with Date Picker control in Excel | Excel Discussion (Misc queries) | |||
Date Conversion Problem | Excel Discussion (Misc queries) | |||
Date format issue | New Users to Excel | |||
date problem in excel | Excel Discussion (Misc queries) | |||
Slight problem automating Excel in a service | Setting up and Configuration of Excel |