Hello I have a cell, formatted as Category :custom and type : is 0000000000 suppose i put value 15.6 in cell it shows me 0000000016 as the cell is formatted that OK. But if I read that cell Its type shows Numeric not formula type. so its give me Out put 15.6 , but as I expect it should be 0000000016. Is it possible to read that cell with Out put as 0000000016 ? If yes how can i read it. Please help. Thanks Rupesh
This is all exactly as expected Use things like DataFormatter if you want to get back a String that looks as your number is formatted in Excel