Query regarding conversion of figures

[pulkit.bachhawat]

My excel sheet has all figures in 1,00,000 and i want to convert them in 1,00,00,000. It means that if the figure is 5,00,00,000 then in my excel sheet it shown as 500 and now i want to make all these figures in crores so it would look like 5. Please help me its urgent

[dominicb]

http://www.excelforum.com/excel-gene...f-figures.html