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 Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Format in Thousands 1

Status
Not open for further replies.
Nambiti

Nambiti

MIS
Apr 19, 2004
10
GB
Hi,
I need to format my numbers to thousands.
Example:
57,000 to 57
58,985 to 59
58,350 to 58
Thanks

 
Sort by date Sort by votes
Why not divide by 1000 and round? Something like
Code: 
 Round({value]/1000)

This is for Crystal 8.5. It helps if you specify your verison.

Madawc Williams
East Anglia, Great Britain
 
Upvote 0 Downvote
Thanks Madawc. Just the job.

8.5 is my version. I'll rememember to mention it next time.
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

LauraW
  • Locked
  • Question
Format Numbers in a String
Replies
4
Views
254
LauraW
LauraW
SarahSCPDAdmin
  • Locked
  • Question
Can I format data in a memo field? 1
Replies
5
Views
203
SarahSCPDAdmin
SarahSCPDAdmin
sofseattle
  • Locked
  • Question
Crystal formula for barcode display shows extra characters in date format?
Replies
1
Views
187
BobSuruncle
BobSuruncle
ejastia
  • Locked
  • Question
date format spacing 1
Replies
4
Views
167
ejastia
ejastia
milisql
  • Locked
  • Question
Column Header in CrossTab Report
Replies
1
Views
361
hilfy
hilfy

Part and Inventory Search

Sponsor

Back
Top