Jump to content

Caly 2018 Excel decimal places


---
 Share

Recommended Posts

I wonder if anyone is working on a weekend 😉

How to make C2018 export 3 decimal places (metric system) instead of all of them?

"Resources-> Characteristic Settings Editor-> Number of decimal places" won't affect Excel export

"Extras -> Settings _> Environment -> Language" won't affect Excel export

I know I can format decimals in the Excel template but I will affect display only

 

 

image.png.bdc7779458bf1bc93eedbd45aa6535b7.png

 

Link to comment
Share on other sites

Try "Measurement Plan Editor Features > Units > All three settings" there. I generally use table file to import results, but maybe it affects excel export too. I know there have been some changes to excel results export in 2025 so I'm not sure how it differs from 2018.

  • Like! 1
Link to comment
Share on other sites

Thank you

Measurement Plan Editor Features > Units > Number of decimal places Table file

I'd never look there

 

image.png.78623b5cf6556a6dd449fb0e363cbf02.png

  • Like! 1
Link to comment
Share on other sites

You got what you needed, but I thought I'd mention...

Yes, others are working the weekend 🙃

  • Like! 1
Link to comment
Share on other sites

I know this might be a little late, but for future reference, the best place to edit it is in the Excel template itself. Grab a chunk of cells that would be cover all the data you expect to get, edit the formatting to only show like 3 or whatever decimal places and save it (remember to save it in the correct format and location).

Link to comment
Share on other sites

 Share

×
×
  • Create New...