Re: Get cell value with format from external dtshe
Do you see the " 100,100,100.00 "in the cell in the excel sheet?
if no, i have an answer for that
Even entering the data in the format of " 100,100,100.00", still it displays as "10010010000".. the reason behind this is the format of cell it is select to " (Custom and type to 0).. change the format of the cell to currency or number or general and try it..
Hope it works..