Issue with conversion to csv
Our client will load a csv to Anaplan where we will compute the scorecard base on the dates on their transactions. However, we notice something the contract number column which is a general format in excel becomes scientific format once it is in csv. Please see attachment. We can change it back to the format that we want to but we need to always check it before loading. Is there a way for the client not to check the format of the csv all the time.
Thanks in advance.