Search results

Thanks for the tip. Here's what I came up with: Format([Division],IIf(Int([Division])<>[Division],"00 00 00.00","00 00 00")) It seems to be working for now. I tried to use Mod but there must have been a rounding error. FYI, the reason I needed the numbers to be formatted with spaces is...

I have been trying to format a field that has some values with decimals some without to look like this: 12 34 56.78 or 12 34 56 If I put "00 00 00.##" it leaves the decimal if there is no decimal place, but if I put "00 00 00" it will round the values with a decimal. 12 34 56 -> 12 34 56...