G
Guest
I had this question earlier today. 2 MVPs I highly respect and
I tried to solve this, but it's ornery...
I have this calculation..
=Round([Text148]/([Text147]/60),2)
...in a Group Footer.
If the calc is 62.00, it displays as as 62...if it's 57.50, it displays
as 57.5. All other values are rounded to 2 decimal places...
I'm Formatting as Fixed, 2 decimal places. Even tried Standard,
2 decimal place and "Auto" decimal places.
Hoping someone here has the solution...if only we could do like
Excel's - "Format - Cells - Number - 2 Decimal places"...that always
seems to work.
TIA - Bob
I tried to solve this, but it's ornery...
I have this calculation..
=Round([Text148]/([Text147]/60),2)
...in a Group Footer.
If the calc is 62.00, it displays as as 62...if it's 57.50, it displays
as 57.5. All other values are rounded to 2 decimal places...
I'm Formatting as Fixed, 2 decimal places. Even tried Standard,
2 decimal place and "Auto" decimal places.
Hoping someone here has the solution...if only we could do like
Excel's - "Format - Cells - Number - 2 Decimal places"...that always
seems to work.
TIA - Bob