IO_Dork
asked on
Remove thousands separator
I have a formula field that combines number with a letter combination, i.e. "CD-" & {trade.invoicenum), results in CD-123,456.00.
I want to remove the comma and decimals so it looks like this:
CD-123456
I know how to use the totext to eliminate the decimals, but how to I get rid of the commas?
I want to remove the comma and decimals so it looks like this:
CD-123456
I know how to use the totext to eliminate the decimals, but how to I get rid of the commas?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER