View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default Data types Questions

that is my understanding.

--
Regards,
Tom Ogilvy

"Mario Reiley" wrote in message
...
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" escribió en el mensaje
...
As I understand it:
all numerical data in an excel worksheet is stored as an IEEE double.
Maximum precision of approxmately 15 digits.

--
Regards,
Tom Ogilvy

"Mario Reiley" wrote in message
...
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