ExcelBanter - Conversion of actual fig. in Lakhs / Crores

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Conversion of actual fig. in Lakhs / Crores (https://www.excelbanter.com/excel-discussion-misc-queries/12052-conversion-actual-fig-lakhs-crores.html)

Ajit Munj

Conversion of actual fig. in Lakhs / Crores

I use Excel 2000 (9.0.2720)

In range A1:D10, I have entered the figures in actuals (e.g. 34532642.45,
78945624.89 etc.). How can I convert those figures in Lakhs / Thousands /
Crores? Before converting, Can Excel 2000 prompt me for conversion in Lacs /
Thousands / Crores?

All times are GMT +1. The time now is 09:14 AM.