I think I have not explained the problem properly. I have always to put a decimal at the Lacs place manually and then I fill the value in the cell. e.g. if I get a value of 56982153 to fill I convert it 569.8 manually and the fill 569.8 in the cell. It is very tedious for a lot of data. So I want that I should fill 56982153 in a cell and it should be converted to 569.8 automatically in that cell.