Loading...
Quick Links

Reply To: Help in formatting a custom numbers field

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

#6964
CommunityCommunity
Keymaster

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.