Rounding Down

  • Thread starter Thread starter John
  • Start date Start date
J

John

Hi I have tried the forms NG's but no help so I am trying the same approach
now on a report.
How to I get a calculated figure of £1.925 to show as £1.92
This is a calculation for the VAT paid on a total price of £11.00
I need this to show the true figure to 2 decimal places not the rounded
figure access shows.
I know that calculations are based on the true figures of £1.925 but I need
it to show on my report as £1.92

Regards

John
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Rounding 2
Excel Stop Excel from displaying rounded values 4
Don't Round Total 4
How can I round a number to 2 significant figures 2
rounding is ignored in calculated control 4
Excel Excel 2007 won't stop rounding down my formula results! 5
Run report on the 5th of every month automatically 0
Force Currency to end in .00 4

Back
Top