Wim, the expression will remove all the leading/trailing zeroes & decimals from the field; if we don't want that we can use only ltrim & remove the decimal replace part i.e.

replace(ltrim(replace(char(<FIELD_NAME), '0', ' ')), ' ', '0')

It basically depends upon requirements. Leading zeroes may be removed, comma & decimal characters wont be removed.

Thanks