Excel- big amount problem
Excel- big amount problem
Whenever I extract data from CRM in excel, The values that are greater than or equal to
10,000,000 gets converted into something like "1.0E7"
A solution that I know is removing ' sign from the value. ( '10000000 to 10000000 )
But it is not possible when there are multiple figures, kindly provide a concrete solution for the same.