How to convert all figures of a sheet from billion into million.

[vishal waghela]

Hey,, any buddy can help me out,, how to convert all figures of a sheet from billion into million,, or from crores to lacs..

in all situations like if its feeded no. or fomula given..

 

[Hui]

type 1000 into a cell

Copy the cell with 1000

Select Cells with Billions

Paste Special all Divide