Many a times you facee this prbolen in excel that you are not able to conevrt the cell in which some date is enetred ins oem format and you are not able to change it in requried format
or it is saved as text e.g.
Date entered is 30/06/2013
even if you change the format to 30-Jun-2013 it does not change
so in this case you just multiply the date by 1 and it will show you the result.
simple and powerful solution for those who juggles with excel for the same.
A Helping hand
CA CS Prakash Somani
CAclubindia
