cell.RichText.Text v/s cell.Value.Tostring()

Sep 19, 2016 at 8:32 AM
Hi,

I'm trying to read an excel file to get the formatted values for each cell and i'm having issues getting the correct value.
I have a cell with the value : 549.78
cell.RichText.Text is returning : (* 549,78) rather than 549.78

So shall i use cell.RichText.Text to get the formatted value or just use cell.Value.ToString()?

Thanks,
SanjeevM.