Hi, 
We're migrating data and I need to set the audit fields with created date which is a datetime format field. I tried everything but it just errors out on me. My current format is: mm/dd/yyyyThh:mm:ss".000GMT+01:00" 
However, this one won't work for me. Anybody knows the right format and has an example on how to set this in formatting in Excel?

Thanks

Immediate Requirement plz give approaches
I have Exported Account object records using DataLoader. ID's in the csv(Excel) file have (a0r90000008cJzaAAE) 18 digit.But i want those as (a0r90000008cJza)15 digit in the same sheet or other Excel Sheet.

I write formula "=LEFT(A2,15)", it was truncated but when i tried to copy those cell to other Excel sheet It's getting nothing like blank because it was a formula cell.

What to do?

Plz give me approaches 
 

We created a custom field on both the Opportunity and Activities called "Next Step" <-- Long Text

I'd like to update the NEXT STEP on the OPPORTUNITY anytime an activity (Event or Task) contains a next step (or is subequently updated).