I hav got in excel the date as 10609 (this is 1st june 2009), how do I convert this 10609 to 01/06/09??? I have many dates (over a thousand) so i cant do it manually.
2 Replies
Subodh
( )
(402 Points)
Replied 02 July 2009
Hi Swapnil
=LEFT(C2,LEN(C2)-4)&"/"&MID(C2,LEN(C2)-3,2)&"/"&RIGHT(C2,2)
suppose the date is in cell "C2" then put following formula:-
Check it will work.... Subodh(Pune)
PRAVEEN KUMAR
(MBA (Finance) B.Com.(P))
(3443 Points)
Replied 03 July 2009
you can also try this formula
this will convert the text in Date format as per excel, which will be easy you use,
like if you want to write
10609
and you want to show it as
1-Jun-2009
this will remain in exact date format as per excel, which is easy to sort / filter later on if required.
suppose your 10609 is in A1
formula is
=DATEVALUE(LEFT(A1,1)&"/"&MID(A1,2,2)&"/"&RIGHT(A1,2))
it will be converted into Date Value
39995
now you can change date format to see date in any desired format.
Thanks
& Best Regards
Praveen
Recent Topics
- CLAIMING OF U CLAIMED RCM
- Building construction works
- REGARDING GSTR-9 F.Y 2023-24
- Rectification to decrease income in SCHEDULE OS
- Can Statutory Auditor of a subsidiary become concu
- Client Asking for the Revised Invoice
- Share office desk in bkc, near family court
- 80D claim for payment paid by parent
- TDS on purchase of Flat under subvention scheme be
- GST registration for medical shop in Karnataka
Related Threads
CAclubindia
