Please login or register.

Login with username, password and session length
Advanced search  

Author Topic: CSV Summary  (Read 2101 times)

Dhwalke

  • Newbie
  • *
  • Karma: +0/-0
  • Posts: 1
CSV Summary
« on: June 07, 2022, 03:06:44 PM »

New to the forum, thanks for the help. Question: Exporting a CSV Summary and when a quantity is above 999, the comma separator is any of the quantities over 999 will confuse the spreadsheet program (Planmaker) and throw off the delineation of columns. Is there a way to eliminate the thousands separator (comma) from the numbers over 999?
Logged

james

  • Newbie
  • *
  • Karma: +0/-0
  • Posts: 3
Re: CSV Summary
« Reply #1 on: July 06, 2022, 11:31:43 AM »

If you go to Preferences -> Import/Export -> Excel, you can change the thousands separator.  Changing it to "None" is probably best.
Logged