function readOnly(count){ }
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
+ Start a Discussion
VRKVRK 

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)
 
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
SwethaSwetha (Salesforce Developers) 
HI VRK,
Recommend trying the approach mentioned in https://trailblazers.salesforce.com/answers?id=9063A000000lDlxQAE

See related: https://trailblazers.salesforce.com/answers?id=90630000000gjW2AAI
VRKVRK
thanks for your response.
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 
 
Suraj Tripathi 47Suraj Tripathi 47
Hi,

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