How to format decimal
lokesh.mathur.24
Posts: 7
Hi all,
As we all know that Navision is comma seperation in Values more than thousand for all decimal fields,
Can any one give me the format expression to format this decimal field into non comma seperation Value,
Thanks
As we all know that Navision is comma seperation in Values more than thousand for all decimal fields,
Can any one give me the format expression to format this decimal field into non comma seperation Value,
Thanks
0
Comments
-
th number formating depends on your regional setting. unless you to convert it to a
string.
Mystr := delchr(Format(MyInt),'=',',');0 -
or you could use the FORMAT command
MESSAGE('%1',FORMAT(10000.1,0,'<Precision,2:2><Standard Format,2>'));
Albert0
Categories
- All Categories
- 75 General
- 75 Announcements
- 66.7K Microsoft Dynamics NAV
- 18.8K NAV Three Tier
- 38.4K NAV/Navision Classic Client
- 3.6K Navision Attain
- 2.4K Navision Financials
- 116 Navision DOS
- 851 Navision e-Commerce
- 1K NAV Tips & Tricks
- 772 NAV Dutch speaking only
- 611 NAV Courses, Exams & Certification
- 2K Microsoft Dynamics-Other
- 1.5K Dynamics AX
- 253 Dynamics CRM
- 103 Dynamics GP
- 6 Dynamics SL
- 1.5K Other
- 991 SQL General
- 383 SQL Performance
- 34 SQL Tips & Tricks
- 28 Design Patterns (General & Best Practices)
- Architectural Patterns
- 9 Design Patterns
- 4 Implementation Patterns
- 53 3rd Party Products, Services & Events
- 1.6K General
- 1K General Chat
- 1.6K Website
- 77 Testing
- 1.2K Download section
- 23 How Tos section
- 249 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions
