4 Replies Latest reply on Oct 21, 2013 9:08 PM by Dan Aspinall

    possible to change default number format from comma delimited 000s with two decimal places?

    Dan Aspinall

      Hi there.


      I am using an extract with tens of different ID values that I want in simple number format, no comma delimiting, no decimal places.

      When I plot these values and "view data", all the ids have comma delimited 000s and two decimal places (.00).

      Is there any way I can default any number value to not show this formatting?  I don't really want to do it for each id field as there are so many.  I was looking for a global setting but couldn't find the correct place to do this. 

      On my database these fields are NUMBER format (Oracle).

      Any assistance much appreciated.

      Capture PO.PNG.png