PachecoPrimo
asked on
Remove time stamp from date in ms excel
I have a spreadsheet that contains a column with the date, however, the column also seems to have a time stamp concatenated to the date. I would like to remove the time stamp so that the date appears as I wanted (ex 11/01/2010). I have attached a spreadsheet for you to see what information I have.
Any assistance will be greatly appreciated.
removetimestampfromdate.xlsx
Any assistance will be greatly appreciated.
removetimestampfromdate.xlsx
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
You can use a formula =TODAY()