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????
Decimal place fix
Collapse
X
-
Format the cells in Excel.sigpic
Originally posted by AndersII've got one from September 2006 (bug ticket) which has finally been fixed in 2013.
-
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.sigpic
Originally posted by AndersII've got one from September 2006 (bug ticket) which has finally been fixed in 2013.
Comment
Related Topics
Collapse
-
by quadman21Is there any way to change this? Everytime I save a report to a text file then view it in excel all the data is rounded to the nearest number?
-
Channel: DataSuite SPC
04-09-2008, 09:13 AM -
-
How do you change the data report from 3 decimals to 4 decimals?
-
Channel: PC-DMIS for CMMs
07-13-2012, 03:39 PM -
-
I change display precision occaisionally in the Pcd report window between 4 and 3. Apparently this remains unchanged in datapage output which is always...
-
Channel: DataSuite SPC
08-20-2009, 12:09 PM -
-
by hfowlerCan someone help me with this question a customer asked me....It concerns the deciaml output on the cmm reports...."how many digits is needed to...
-
Channel: PC-DMIS for CMMs
01-26-2010, 09:28 AM -
-
by rbexplorerHi everyone,
can you help me with my problem, please?
Can I display measuring results into 7 decimal places in report? Where...-
Channel: PC-DMIS for CMMs
03-01-2010, 06:45 AM -
Comment