solution I'm going with then is to change my [standard] field to a numeric and enter everything as a decimal (boolean are 1 and 0, 99.95% is 0.9995, etc.) and using mid(totext([standard])) to grab digits at certain places and insert the "." and "%" where appropriate.

*(I am of course using a case function for boolean, integer or percentage, just working on the percentage part now)*The problem I'm running into now is that the system isn't keeping leading/trailing zeroes, so percentages that are single digit or have no value after the inserted decimal point will not show up properly. Is there a way to tell Quickbase that I need to keep all the leading/trailing zeroes on a field?