Reply To: Help in formatting a custom numbers field

Home Forums Discussion Forum Help in formatting a custom numbers field Reply To: Help in formatting a custom numbers field

#6964

From memory, you can use a mixture of instr and left to find the number of characters to the left of the period (.) and then return the number of characters to the left of the (.)  this wouldn’t round it up, just truncate it.  A number field formats to 2 decimal places.