converting from Rupees to Rupees in lacs

[gopalakrishnarao1]

Hi,
I am having some data in a sheet containing the values in actual Rupees (Indian Currency). It is to be converted into Rs. in lacs. Pl. give the formula. Data is in 5 columns. Where I have to enter the formula for converting.
Advance thanks for the solution providers.

 

[sanrv1f]

Welcome to the board,

try this

Excel Workbook
	G	H
1	Rupees	Rupees in lacs
2	4500000	45
Sheet1

Excel 2003

Cell Formulas
Range	Formula
H2	=G2/100000

 

[gopalakrishnarao1]

Sincere thanks for the immediate solution provided. All the best & have a nice and joyful day.

 

[galaxyee]

Sincere Thanks for providing solution