Question – How to Convert date/time value to a date value (remove time portion) in Excel.
Scenario – Running short of time
Task – Need to push the data in Salesforce.com through the help of Data Loader.
Error Message – Error converting value to correct data type: Date Conversion FAILED.
Solution – Here we have a date/time value in cell A1 and we’d like to remove the time portion from this value. In cell B1, we’ve entered the following formula:
=MONTH(A1) & “/” & DAY(A1) & “/” & YEAR(A1)
Then paste the value (using paste special) in next cell. (See the screenshot below) –