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

Removing the (,) comma 1

Status
Not open for further replies.

ashark

Programmer
Nov 21, 2002
31
0
0
IN
Hi Group,
I have customized a group name.
It consists of a number field and a string field.
eg. I have employee Number and Name
123456Employee1
My problem is I am getting a comma (,)
123,456Employee1

How can I remove the (,)????

Regards,
ashark
 
Right click the number field, hit Format, Customise, and uncheck the thousands seperator.

Naith
 
If Naith's solution didn't work....

Is the field a concatenation of two fields? If it is, try this: totext({your number field},0,"")+{your other field}

Mike
If you're not part of the solution, you're part of the precipitate.
 
Hi Naith, mbarron,
I had tried by removing the Thousands separator but it didn't work.
But by using totext({your number field},0,"") I could remove the (,).

Thanks for your help.

Regards,
ashark
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top