Reply To: Help in formatting a custom numbers field

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

#6964
Avatar photoCommunity
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.