I have a number field and stores ssn’s. when pulling the field to a report it displays like this: (00,001,234.00 or 000, 001,234.00).

I tried this formula: [right(totext ({AGMRK_UPD_CLIENT.TAX_ID_NBR}),4)], but the results display as 4.00, I tried changing it from 4 in the formula to 8 and that displays as 1,234.00.

I need a Crystal reports formula, that allow me to only display the true last 4 digits of the ssn (1234) without comas, periods or the last 2 zeros, please and thank you.