Tweet
Hi
I just begin with DDE coding in excel... I know the basis and everything seem to work fine BUT the numbers are badly displayed.
Snp, per exemple, will return ''845.75000000000''. Because of that, Excel do not recognize the cell as a number and i cannot apply any formula to the price.
I know how to edit the ''cells format'' but nothing's doing it. I cannot edit the decimal or any format of my matrix... its always displaying as 'twelve' digits after the dot...
When I apply a formula to a number, it returns ''#VALUE!''
Do you know what i can do to resolve the thing ?
Excel 2007 (second fresh installation), esignal 10.0 (third fresh installation), winXP sp3
- Bill
please note that its working fine with most of the computer in my office, but not on mine, so I really don't know what is the problem
I just begin with DDE coding in excel... I know the basis and everything seem to work fine BUT the numbers are badly displayed.
Snp, per exemple, will return ''845.75000000000''. Because of that, Excel do not recognize the cell as a number and i cannot apply any formula to the price.
I know how to edit the ''cells format'' but nothing's doing it. I cannot edit the decimal or any format of my matrix... its always displaying as 'twelve' digits after the dot...
When I apply a formula to a number, it returns ''#VALUE!''
Do you know what i can do to resolve the thing ?
Excel 2007 (second fresh installation), esignal 10.0 (third fresh installation), winXP sp3
- Bill
please note that its working fine with most of the computer in my office, but not on mine, so I really don't know what is the problem
Comment