1 Crore = 0.01 Billion, Crores and Lakhs of Rupees are dealt in India. I made a pivot table on Revenue Budget using power Query, wherein all the Numbers are displayed by default in Thousands of Rupees. As 10,000 Thousands make One Crores, if I use number formatting like #,##0.0,, will give me in Ten Lakhs of Rupees and if I use #,##0.0,,, this will give me Number of Rupees in Hundred Crores. I need to display only in Crores. Thanks in advance for your kind support.