Formatting Number formula using Crystal 10

[Stewman]

Hello,

I am using Crystal 10 and am creating a formula that combines a employee id with the first and last name. However, when I combine the employee id in it shows with a comma. I need the employee id to have no commas.

example of how it looks
111,111 John Doe

What I want:
111111 John Doe

Formula I am using:
{EMP.EMP_ID},0) & " " & " " & {EMP.FIRST} & " " &{EMP.LAST}

Returning:111,111 John Doe

How do I remove the comma?

Any help appreciated.

Thanks,
Chris

 

[Stewman]

Ooops correction to my formula...I'm using this:

{EMP.EMP_ID} & " " & " " & {EMP.FIRST} & " " & {EMP.LAST}

Sorry about that.

 

[dgillz]

try this:

totext({EMP.EMP_ID},0,"")&" "&" "&{EMP.FIRST}&" "&{EMP.LAST}

Software Sales, Training, Implementation and Support for Macola, eSynergy, and Crystal Reports

http://www.gainfocus.biz

"If you have a big enough dictionary, just about everything is a word"
--Dave Barry

 

[Stewman]

Thanks again dgillz, you come thru again.