Hey I have an integer field type that contains my member numbers. When using these in an email template it is showing them in this format (111,111) but I need them to display in this format (111111). I have tried this formula: to_char(to_date({fieldinternalid},'j'),'Jsp') but it is now displaying like this 'One Hundred Ten Thousand One Hundred Eleven,' Any help please?

@EB Have you tried changing your number format under Home>Set Preferences? Can't guarantee this will work, but I had a sort of similar issues with dates that I had to change my preference for in ordered to get things to work properly.

Hi James, Thanks for this I did end up fixing it in a 'D'oh' moment by unticking 'Apply formatting' in the custom field which worked!