1 of 1 people found this helpful
You can do LEFT (SPLIT(STR([Fieldname]),'.',2) + '00' ,2). This will pad a zero to the field if there is only one digit after the decimal.
You may or may not need the STR, depending on the datatype of your field. The SPLIT will split on '.' and take the 2 part of the string, '+' will concatenate it with '00' and then LEFT will take the 2 left characters.
Then you can append it to SPLIT(STR([Fieldname]),'.',1)
1 indicates the part before the decimal.