Decimal place fix

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • Decimal place fix

    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????

  • #2
    Format the cells in Excel.
    sigpic
    Originally posted by AndersI
    I've got one from September 2006 (bug ticket) which has finally been fixed in 2013.

    Comment


    • DHARTNESS55
      DHARTNESS55 commented
      Editing a comment
      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!

  • #3
    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 AndersI
    I've got one from September 2006 (bug ticket) which has finally been fixed in 2013.

    Comment


    • DHARTNESS55
      DHARTNESS55 commented
      Editing a comment
      Thanks, That is kinda what I thought, but we didn't have this problem with Windows 7., just started with Windows 10.

Related Topics

Collapse

Working...
X