Apex Code Development You need to sign in to do that
Don't have an account?
VRK convert thousand to millions
Hi folks,
we plan to migrate existing data from thousand to millions .
my approach here is :
i. i need to export data
ii. convert thousand to millions in excel sheet
iii. update new data
But i am in struck in convert data to Million ....i saw few articles in google, its not much clear .
exisitng field data type is (Currency(16, 1)
can anyone help me to covert data to Millions ....in excel .
or if you have any best approaches pls suggest
Thanks
VRK
we plan to migrate existing data from thousand to millions .
my approach here is :
i. i need to export data
ii. convert thousand to millions in excel sheet
iii. update new data
But i am in struck in convert data to Million ....i saw few articles in google, its not much clear .
exisitng field data type is (Currency(16, 1)
| 11434 |
| 1828786 |
| 960 |
| 14426 |
| 2862161 |
| 2056369 |
| 2342 |
can anyone help me to covert data to Millions ....in excel .
or if you have any best approaches pls suggest
Thanks
VRK
Recommend trying the approach mentioned in https://trailblazers.salesforce.com/answers?id=9063A000000lDlxQAE
See related: https://trailblazers.salesforce.com/answers?id=90630000000gjW2AAI
But my request is for existing data , i am doing this activity by using Data loader
In excel sheet,i am plan to covert data to millions
So any idea how to convert data to Millions in excel sheet
Please follow the below link, I hope you will find your solution.
-https://www.airweb.org/article/2018/01/16/formatting-numeric-data-to-millions-in-excel
-https://www.dummies.com/software/microsoft-office/excel/format-numbers-in-thousands-and-millions-in-excel-reports/
Please mark it as Best Answer if it helps you.
Thanks & Regards
Suraj Tripathi