cancel
Showing results for 
Search instead for 
Did you mean: 

Get Collection Fast - Converting UK Date to US Date

Anonymous
Not applicable
BP V5.2. importing the left hand excel as a collection in bp but its changing the format from UK date to US Date, I€™ve trawled the forums and asked everyone in my office to no avail of how to fix this issue. do you know of a way to get bp to import it correctly so the date isn€™t altered?
1 REPLY 1

MayurGangrade
Level 4
Hello Daniel, If possible, could you share dummy excel file. Before processing your excel try changing cell formatting to text, this should work.