Or how about this?

Right click the field, select Properties- Format Tab, put P2 in the format code field.

Here are some links to microsoft cheat sheets.

•FORMAT STRINGS

•Standard Numeric Format...

Thanks, all for the information. I won't have time to try it for a few days, but will make some tests next week and report back to you.

Thanks bunches! 🙂

Thanks Mark for the clarification. If I can remember back that far (one week!) 😉 it seems like I tried them all and got errors. I'll test them again.

PS Still...

I'm new at this, but I'm told the solution supplied above only works with ungrouped data. I've been supplied with a formula that's supposed to work with grouped data, but...