I have a C# windows application that imports data from EXCEL files. Right now it just reads in the unformatted data meaning this is the data without any EXCEL masking or special or custom formatting. For example;
Stock Number Cell
The cell above shows value 4.50 when opened in EXCEL but the real value is 04.5099383. I want to know if it is possible to read in the formatted value which in this case would be 4.50 instead of the unformatted value. How can I do this in c#? I am using Visual Studio 2010.