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!

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

Format Field adding zeros to left

Status
Not open for further replies.

jpfoliveira

Programmer
Feb 2, 2003
1
PT
Hi all,
I've a field that i want to present with 4 digits, so i must format like: "0001" and not like he is reported "1".
Someone can help me?
Tks in advance.
 
Try something like Totext ({arec.number}, "0000"). This applies for Crystal 8.5, at least. For an older Crystal you might need to say Cstr instead.

You'd get a quicker response posting this sort of inquiry to Crystal Reports 1 Formulas, which has all sorts of neat tricks documented Madawc Williams
East Anglia
Great Britain
 
Here is a good discussion of the question:
thread149-465074
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top