Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

format US number format to Indian number format

Status
Not open for further replies.
rohitrdx

rohitrdx

IS-IT--Management
Joined
Oct 21, 2003
Messages
1
Location
IN
how to format 1,810,683.86 to 18,10,683.86
in crystal repors
 
Sort by date Sort by votes
hi
just fromat to string
ex:
16125.00
###,###.#
_16,125.0

18,10,683.86
##,##,###.##

cheers




pgtek
 
Upvote 0 Downvote
For Crystal 8.5, try
cstr ({your.number}, "##,##,###.##")

Madawc Williams
East Anglia, Great Britain
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

P
  • Question Question
Message: Error fetching / setting data for report. Exception: Object reference not set to an instance of an object
Replies
1
Views
68
rinzana
rinzana
Kennymc
  • Locked
  • Question Question
Crystal connection to Microsoft business central 365
Replies
0
Views
1K
Kennymc
Kennymc
s_reddibathuni
  • Locked
  • Question Question
export multiline address field from crystal to excel
Replies
3
Views
1K
hilfy
hilfy
Ivan Kok
  • Locked
  • Question Question
Crystal Reports Runtime causing AS/400 DB2 Database ID to be disabled intermittently
Replies
0
Views
1K
Ivan Kok
Ivan Kok
RenaG
  • Locked
  • Question Question
Max number of tables in the datasource for Crystal Reports
Replies
0
Views
303
RenaG
RenaG

Part and Inventory Search

Sponsor

Back
Top