Numbers appearing as text

[AntonioPerera]

Crystal reports 11

I am incorporating some number fields into a formula.

E.g :
Batch number - 110
Entry number - 1
Sequence number - 1802

My formula is :
Batch number&"-"&Entry Number&"-"&Sequence number

I want my result to look like this

110-1-1802

However, it appears as :

110.00-1.00-1,802.00


Please let me know how I can achieve my desired output

 

[MCuthill]

AntonioPerera,

The following formula should give you the desired results:

ToText({Batch},"0")&"-"&ToText({Entry},"0")&"-"&ToText({Sequence},"0")

Hope this helps!

Mike
---------------------------------------------------------------
"To be alive is to revel in the moments, in the sunrise and the sunset, in the sudden and brief episodes of love and adventure,
in the hours of companionship. It is, most of all, to never be paralyzed by your fears of a future that no one can foretell."

 

[lbass]

ToText({Batch},0,"")&"-"&ToText({Entry},0,"")&"-"&ToText({Sequence},0,"")

-LB