Data types Questions

[Mario Reiley]

Hi group

I am porting several Excel files to Winforms C# .NET application. but I
having problems with some calc with lost precition.

so How can I find the internal representation in memory of the Excel data
types. i.e , When I put a number (INteger, float,Decimal.....) in cells.

Best Regard
Mario

 

[Tom Ogilvy]

As I understand it:
all numerical data in an excel worksheet is stored as an IEEE double.
Maximum precision of approxmately 15 digits.

 

[Mario Reiley]

OK, let me try understad:

if I put 1 or 0.1 or 11.50 or 234 in one cell , all this number are doble
presicition 64 bit. ?

Thanks for respond me
Mario

 

[Tom Ogilvy]

that is my understanding.