how do I reduce the decimal value output from Datapage to an excel spread sheet. Even though I only display 2 decimal places in Datapage, it dumps out 13 decimal places in excel????
Matt,
If I only display 3 places coming out of PC DMIS and into Datapage, and only displaying 3 places in Datapage..... How am I getting 13 places dumping into excel. In excel I have it formatted to display 2 places which it does, but when I click on a cell to "Fix" something, there are 13 decimal places shown!
Pcdmis carrys out to 13 or 20, no matter what you have displayed. All those places go into Datapage. They all come back out as well. IF you are using Datapage RT, I know how to make the REPORTS only go to so many places, but the full data is still there.
