Remove COMMA(')

Comments

• kriki Member, Moderator Posts: 9,118

  2010-04-19

  [Topic moved from 'NAV 2009' forum to 'NAV/Navision' forum]
  
  Check the format-property on the field in the report.
  With that you can select how many decimals you want and how the format must be.
  
  Curiosity : what is the Indian format?

  Regards,Alain Krikilion
  No PM,please use the forum. || May the <SOLVED>-attribute be in your title!
  
  

  0
• ashrafcbz Member Posts: 10

  2010-04-19

  hi,
  thanks for reply.
  
  eg::indian 1,00,000.00
  in navision it shows 100,000.00

  0
• ashrafcbz Member Posts: 10

  2010-04-19

  kriki wrote:

  [Topic moved from 'NAV 2009' forum to 'NAV/Navision' forum]
  
  Check the format-property on the field in the report.
  With that you can select how many decimals you want and how the format must be.
  
  Curiosity : what is the Indian format?

  
  
  for removing COMMA how can i set the formate property.

  0
• matttrax Member Posts: 2,309

  2010-04-19

  Seems like a strange format. Still, look into the FORMAT function and property. If you cannot find the options to create the format you want you will have to build your own function. I can't imagine the Indian number formatting wouldn't be there, though.

  Matt Traxinger - ArcherPoint

  0
• hawkeye Member Posts: 51

  2010-04-20

  I would use the DELCHR function. Look in help how to use it. It can delete all your commas

  0
• Hanen Member Posts: 281

  2011-04-13

  NewAmount:= DELCHR(Amount,'=',',');

  Regards
  
  Hanen TALBI

  0
• MGM08 Member Posts: 41

  2011-04-15

  viewtopic.php?f=23&t=47012
  
  Hope this helps

  0
• vaprog Member Posts: 1,155

  2011-04-24

  NAV standard format uses Windows regional settings. You might want to take a look on those.

  0
• st0328 Member Posts: 97

  2011-04-25

  Hope this helps
  
  http://www.mibuso.com/forum/viewtopic.php?f=1&t=46854

  0