uttamsaxena
Board Regular
- Joined
- Apr 22, 2003
- Messages
- 182
In a sheet, I have a column in which I fill values based on the inputs given to me. The values, which I get, are in absolute numbers e.g. 456231, 5689456, 456387 etc. but I have to fill value in lacs of these nos. I mean I have to fill 4.5, 56.9 and 4.6 against the received numbers. I mean I want that on filling any value in the cell, it should get converted to Lacs and rounded to 1 decimal place.