HI,
need to convert 9/27/2012 12:00:00 AM in dd/mm/yyyy format. Please suggest a excel formula.
HI,
need to convert 9/27/2012 12:00:00 AM in dd/mm/yyyy format. Please suggest a excel formula.
The given date in the sheet is not in a date format.
use the below formula in Cell C2 and drag it down.
Formula:Please Login or Register to view this content.
c2=IF(B2<>"",INT(VALUE(B2)),"")
copy down
custom format dd/mm/yyyy
Last edited by CARACALLA; 03-15-2020 at 06:45 AM.
Thank you! Shareez Saleem. Bro, you have solved my problem.
it depends on regional settings
Please Login or Register to view this content.
BMV Bro! Yes, it is also worked. Thanks a lot.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks